Shutdown the instance back it up as a safety.
Deinstall the EE edition of the software install SE. Works best if you use a
different $ORACLE_HOME. Start the instance run catalog catproc from
$ORACLE_HOME/rdbms/admin. If you had run catrep run catnorep. Shutdown
backup again your done.
Hi Charlie
Via SQL*Plus I get connected without any problem via SQL*Net.
When using the JdbcCheckup.java program,it sends back messages on whatever
has gone through and one of them is the notification that it has connected
successfully.
If you look at the program which as I mentioned earlier on
Specify the size as 99M. You will not get an error.
(why??? I will leave that reason to you ;)
Best Regards,
K Gopalakrishnan
Bangalore, INDIA
-Original Message-
[EMAIL PROTECTED]
Sent: Tuesday, March 26, 2002 3:43 AM
To: Multiple recipients of list ORACLE-L
Hi List,
First time
** Mayo Sees Databases As Way To Improve Treatments
The Mayo Clinic and IBM are developing an advanced medical
database that would combine clinical records with demographics
and even genomic information to give medical researchers a
resource for supporting clinical trials and improving
Never mind, REF_CURSOR should be REF CURSOR. It's early
Rick Cale
What is the impact of striping on index range scans?
Since we striped our disk that our indexes are located on,
we have been showing more than thirty times the number
of rows read during index range scans.
How does disk striping (in our case using Veritas volume
manager) affect range scans?
Hi DBAs,
I have I think is a very simple package but I cannot get it to compile
because of the following error. Can anyone see what the problem is? The
message suggest an error in the specification. Wow only 2 lines of code in
the spec.
PLS-00905: object PKG_ARGS is invalid
PLS-00304: cannot
What is the file that I need to edit on my client PC to set personalized settings for
SQLPlus so that I do not have to set these at the command prompt every time I start a
new session?
Thanks,
Dave
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Farnsworth, Dave
CREATE OR REPLACE PROCEDURE rUSERSX(
Pusers IN DBMS_SQL.VARCHAR2_TABLE,
Pweights OUT DBMS_SQL.NUMBER_TABLE)
AS
BEGIN
FOR nJ IN 1..Pusers.COUNT LOOP
SELECT NVL(Weight, 0) INTO Pweights(nJ)
FROM TABLEA
WHERE usera = Pusers(nJ);
END LOOP;
END;
/
Igor Neyman, OCP DBA
[EMAIL
Title: How to duplicate production database onto development box
Hi!
We want to put an exact copy of our production database (approx. 200 GB) onto a development box. What would be the best way to achieve this? Export/import would take kinda long... ;)
Would transportable
I think you just need to create a script called login.sql in the same
directory as you would run SQLPLUS from. Certainly on unix if you login to
SQL from a directory that contains a file called login.sql it will process
the commands contained within it.
HTH
Kev.
-Original Message-
Sent:
Find the table's highwater mark. That tells
you how many blocks are actually in use
holding data, hence the maximum number
of blocks that needs to be buffered.
Remember that when updating or getting
read-consistent blocks, Oracle may clone
blocks in the buffer, and you can get up
to 6 versions
File login.sql in %Oracle_home%\DBS\
Gints Plivna
IT Sistçmas, Meríeïa 13, LV1050 Rîga
http://www.itsystems.lv/gints/
Thanks for everyone's help: Here's my final solution: I had to add 7 to get
the rounding to work correctly.
begin
for x in 1..120 Loop
dbms_output.put_line(to_char(x)|| ' ' ||to_char(floor((x+7)/60)+(.25 *
floor(mod((x+7),60)/15))) );
end loop;
end;
/
-Original Message-
Sent: Tuesday,
I had to read my book to find the answer to this one ;)
If you specify (at least under 8.1.5):
alter table tabX drop column colX;
then there is no checkpoint and you generate
the worst volume of rollback.
If you specify:
alter table tabX drop column colX checkpoint NNN;
then you
$ORACLE_HOME/sqlplus/admin/glogin.sql
On Tue, 2002-03-26 at 07:38, Farnsworth, Dave wrote:
What is the file that I need to edit on my client PC to set personalized settings
for SQLPlus so that I do not have to set these at the command prompt every time I
start a new session?
clone database by copiyng all datafiles and rebuild the controlfile using a
new database name.
[Bernard, Gilbert] -Message d'origine-
De: Daiminger, Helmut [mailto:[EMAIL PROTECTED]]
Date: mardi 26 mars 2002 14:48
À: Multiple recipients of list ORACLE-L
Objet: How to duplicate
Hello list,
I want to know how could I identify the OS user name of a user acceding
an application. Is there any view/parameter that shows it??
A lot of thanks,
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Beatriz =?iso-8859-1?Q?Mart=EDnez=20Jim=E9nez?=
INET:
Hi Gurus,
We encountered the error FS-CANT OPEN TMPFILE when we tried to view the
concurrent request report. Yesterday, we can view any report but not today.
The only thing that's different is that we run the purge obselete workflow
runtime data concurrent program this morning but it should not
glogin.sql
Farnsworth, Dave
Oracle Wants Users to Hand over Apps Management
Putting muscle behind the outsourcing model of application management,
Oracle Corp. said it is starting an international campaign to persuade
customers to hand over maintenance of their Oracle software.
We have decided to go in and actively go
glogin.sql
-Original Message-
Dave
Sent: 26 March 2002 13:38
To: Multiple recipients of list ORACLE-L
What is the file that I need to edit on my client PC to set personalized
settings for SQLPlus so that I do not have to set these at the command
prompt every time I start a new session?
in your oracle /bin directory - you need to alter (Or create) a login.sql
file
here's what mine looks like - feel free to alter
/* start */
set heading on
set pause off
set pages 23
set lines 100
set verify off
set feedback on
set space 1
set serveroutput on size 100
set echo off
Login.sql
-Message d'origine-
De: Farnsworth, Dave [mailto:[EMAIL PROTECTED]]
Date: mardi 26 mars 2002 14:38
À: Multiple recipients of list ORACLE-L
Objet: Customize my SQLPlus login
What is the file that I need to edit on my
login.sql and glogin.sql
glogin.sql will be global, from wherever you start your sqlplus
session, login.sql is run from your current directory so if you have
changed directories it won't be run
--- Farnsworth, Dave [EMAIL PROTECTED] wrote:
What is the file that I need to edit on my client PC
Title: How to duplicate production database onto development box
Hi
There are several ways to move a database :
1 : Shutdown the db and copy all the data files, redologfiles, control file
and the parameter file to the dev box then open the db.
2 : Take a online backup of the database and
Doubtful. Do you think IBM would advocate using another database product
for a new application in development? cool idea though. I dream of being
on a project with a budget like this... Know what the budget was on my last
project? staff = 2 people, hardware/software = $60,000.
Lisa Koivu
May be late in responding... but here's how I did it
I designated one disk associated BCV as a test group - had a sysadmin do
it. I modified a copy of all the shell scripts to only affect that BCV with
all the operations (sync, split, etc.) Then I created a little test db on
that disk only,
Thanks to all who responded!!
Dave
-Original Message-
Sent: Tuesday, March 26, 2002 8:08 AM
To: Multiple recipients of list ORACLE-L
$ORACLE_HOME/sqlplus/admin/glogin.sql
On Tue, 2002-03-26 at 07:38, Farnsworth, Dave wrote:
What is the file that I need to edit on my client PC to
why not just copy over your complete hot backup? If you need it to be
as up to date as possible, you could do it as a standby database and
apply logs until you are ready and then open the standby database and
you will have an exact copy.
Transportable tablespaces have some caveats -- and the
gologin.sql
Here's an example from Oracle:
--
-- $Header: /plus/v3/spam/precious/files/ACTIVE/glogin.sql,v 1.6
1995/07/25 02:33:26 cjones Exp $
-- Copyright (c) Oracle Corporation 1988, 1994, 1995. All Rights
Reserved.
--
-- SQL*Plus Global Login startup file.
--
-- This is the global
On Tue, Mar 26, 2002 at 05:48:23AM -0800, Daiminger, Helmut wrote:
Hi!
We want to put an exact copy of our production database (approx. 200 GB)
onto a development box.
I use a warmbackup to do this on a regular basis. This takes
a long time, also, but it is pretty scriptable, so you don't
Title: How to duplicate production database onto development box
Just
copy the files over and recreate the control file.
Abraham
-Original Message-From: Daiminger, Helmut
[mailto:[EMAIL PROTECTED]]Sent: Tuesday, March 26, 2002
7:48 AMTo: Multiple recipients of list ORACLE-LSubject:
select username, osuser from v$sesssion
Dave
-Original Message-
Sent: Tuesday, March 26, 2002 7:54 AM
To: Multiple recipients of list ORACLE-L
Hello list,
I want to know how could I identify the OS user name of a user acceding
an application. Is there any view/parameter that shows
OSUSER column in v$session view.
Igor Neyman, OCP DBA
[EMAIL PROTECTED]
The degree of normality in a database
is inversely proportional to that of its DBA.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, March 26, 2002 8:53 AM
Hello
However, login.sql will run if it is defined in
the SQL_PATH (or possibly SQLPATH)
environment variable, which is set up using
the same syntax at the normal PATH option,
viz. directory names separated by colons.
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Next Seminar - UK, April 3rd - 5th
You don't say what version of Oracle, but this function will work for 8i and
up:
SYS_CONTEXT('USERENV','OS_USER')
Rich Jesse System/Database Administrator
[EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA
-Original Message-
Sent: Tuesday,
in your current directory put a login.sql file as
login.sql
-Message d'origine-
De: Rodd Holman [mailto:[EMAIL PROTECTED]]
Date: mardi 26 mars 2002 15:09
À: Multiple recipients of list ORACLE-L
Objet: Re: Customize my SQLPlus login
OK. I followed Jared's suggestions and set the following:
HKLM\software\Oracle\ora_sid_shutdown=TRUE
\ora_sid_shutdown_type=i
\ora_sid_shutdown_timeout=300 (5 minutes)
HKLM\system\CurrentControlSet\Control\WaitToKillService=30
Whether it was
Solaris 5.8 Oracle 8.1.7.2
Has anyone successfully renamed the Oracle user on a solaris box? At the
moment I don't a test box and this is a rarely used development system.
The current Oracle user and group are oracle2 and dba2. We have to
change it to match our standards, i.e. oracle dba.
The
I have added some customizations to my glogin.sql. When I start a session of SQLPlus
I get this;
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer Release 8.1.7.0.0 - Production
Input truncated to 13 characters
SQL show pagesize
Title: How to duplicate production database onto development box
if you not affordable to a down time , may be hot
backups will help you out.
1. Copy the Hot backups to a different machine where
you want to have a duplicate database.
2. Edit the Init.Ora and control file
.
3. run the control
Title: RE: Customize my SQLPlus login
If you want it set for yourself, but not for
everyone, AND need it to take effect from
everywhere you run sqlplus,
create a login.sql file in some directory
under $HOME, and then set $SQLPATH to this directory.
Matt Adams - GE Appliances -
Roland,
What a surprise! I thought you were moving to an Access list? Because
I've taken a rather perverse interest in the questions you ask, I'll give
you a hint: triggers and exception handling.
By the way, if no one has answered your question regarding a table of
table definitions, it's
Title: Net 8 installation on a server rather than client question
Question to the list. Is there was way to install Net 8 on a nt server and have client pc's execute the Net 8 from
the server instead of loading Net 8 on the client's pc. To avoid installation of Net 8 on the clients. I already
Another publicity blunder by Uncle Larry.
-Original Message-
Sent: Tuesday, March 26, 2002 8:03 AM
To: Multiple recipients of list ORACLE-L
Oracle Wants Users to Hand over Apps Management
Putting muscle behind the outsourcing model of application management,
Oracle Corp. said it is
Look at view v$session
select username, osuser from v$session;
regards
Volker Schoen
E-Mail: mailto:[EMAIL PROTECTED]
http://www.inplan.de
-Ursprüngliche Nachricht-
Von: Beatriz Martínez Jiménez [mailto:[EMAIL PROTECTED]]
Gesendet: Dienstag, 26. März 2002 14:54
An: Multiple
On solaris, you can set $SQLPATH in your environment and it will look in
that path for a login.sql (and any other .sql files that it cannot find in
the current directory).
-Original Message-
From: Rachel Carmichael [mailto:[EMAIL PROTECTED]]
Sent: 26 March 2002 14:29
To: Multiple
glogin.sql is on my PC but not login.sql. I'm on 9i.
Ken Janusz, CPIM
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, March 26, 2002 9:23 AM
[EMAIL PROTECTED] wrote:
glogin.sql
u... i don't think glogin.sql is on the client
I have added a datafile to a the temp tablespace with the name of .dbf only
is ithis a valid name?, is there any way to rename it without shutdown the
database,if yes HOW?
Thanks
Hamid Alavi
Office 818 737-0526
Cell818 402-1987
The information contained in this message and any
Put a carriage return at the end of the last line.
Farnsworth, Dave wrote:
I have added some customizations to my glogin.sql. When I start a session of
SQLPlus I get this;
Connected to:
Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production
With the Partitioning option
JServer
We have security requirements that do not allow remote
administration. There has been some discussion of vpn
(for two or three years!) but it is likely that vpn
will be for the execs to get their mail rather than
database administration. Unfortunately, it is likely
a security issue to discuss
Title: How to duplicate production database onto development box
I use
a hot backup to create a standby database then apply logs to the
point
I want
to get a copy of production of a specific time.
Then
you can rename the database if you want to.
-Original Message-From: Guerra,
[EMAIL PROTECTED] wrote:
glogin.sql
u... i don't think glogin.sql is on the client PC. well it's not on
mine anyway.;-)
-Original Message-
Dave
Sent: 26 March 2002 13:38
To: Multiple recipients of list ORACLE-L
What is the file that I need to edit on my client PC to
Dave,
It just needs carriage return at the end of the last line.
Iain Nicoll
-Original Message-
Sent: Tuesday, March 26, 2002 4:18 PM
To: Multiple recipients of list ORACLE-L
I have added some customizations to my glogin.sql. When I start a session
of SQLPlus I get this;
Connected
LMAO
Obligatory Oracle Question:
Does anybody have a sample init.ora file that they use for a 9.0.1 instance,
for a sandbox database on Win2K with 512Mb RAM? Basically for my desktop PC
play database..
-Original Message-
[EMAIL PROTECTED]
Sent: 26 March 2002 16:39
To: Multiple
[EMAIL PROTECTED] wrote:
I have added a datafile to a the temp tablespace with the name of .dbf only
is ithis a valid name?, is there any way to rename it without shutdown the
database,if yes HOW?
it depends on your OS. and how you'd rename depends on that too.
--
--
Bill Shrek Thater
What happens if the user then issues a connect statement to connect to
another database?
It would be nice if there was a .sql file run every time a new connection is
set, I don't know if that is the case in the 8i / 9i versions.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-- Hamid Alavi [EMAIL PROTECTED]
I have added a datafile to a the temp tablespace with the name of .dbf
only is ithis a valid name?, is there any way to rename it without
shutdown the database,if yes HOW?
You can ln .dbf name_you_wanted any time you like. Unlink
the .dbf basename whenever
With a free OTN account:
http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/
a85397/function.htm#88700
(Note: The above URL will get chopped in two pieces by MS Lookout.)
HTH!
Rich Jesse System/Database Administrator
[EMAIL PROTECTED]
Hamid,
.dbf is prefectly valid on all machines, as far as I know.
You can rename it - look at the ALTER DATABASE RENAME FILE 'filename' to
'newfilename' clause to rename the data file. You will need to take the
tablespace offline to do this.
Hope this helps
Tom Mercadante
Oracle Certified
.dbf is perfectly OK
-Original Message-
Sent: Tuesday, March 26, 2002 10:39 AM
To: Multiple recipients of list ORACLE-L
I have added a datafile to a the temp tablespace with the name of .dbf only
is ithis a valid name?, is there any way to rename it without shutdown the
database,if yes
Look at
http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a85397/function.htm#88362
JP
On Tue 26. March 2002 17:18, you wrote:
Is there a detailed list of other USERENV information taht I can have
access to by using SYS_CONTEXT?
TIA,
Tamas Szecsy
-Original
not in Oracle_home/sqlplus/admin?
It is on mine.. Then again, mine has a database on it as well.. ;)
-Original Message-
Sent: 26 March 2002 15:24
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED] wrote:
glogin.sql
u... i don't think glogin.sql is on the client PC.
check sqlplus\admin under ORACLE_HOME
--- bill thater [EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] wrote:
glogin.sql
u... i don't think glogin.sql is on the client PC. well it's not
on
mine anyway.;-)
-Original Message-
Dave
Sent: 26 March 2002 13:38
To:
It's possible that you have a line in the file
(perhaps the last line) that consists
of a string of blanks; or the last command
line of the file does not have a carriage return.
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Next Seminar - UK, April 3rd - 5th
Robert,
If I understand your requirements correctly,
You have multiple sites separated geographically ( 200
Miles perhaps..?? ) and you are looking for a highly
available , 'Multimaster' kinda environment.
This kind of setup is common in
oh-don't-say-the-name-companies i.e. 'dot bombs' and
Drop and recreate your temp tablespace.
Scott Shafer
San Antonio, TX
210-581-6217
Common sense will not accomplish great things. Simply become insane and
desperate.
-Original Message-
From: Hamid Alavi [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, March 26, 2002 10:39 AM
To: Multiple
Nothing happens, the prompt stays the same unless you run @login, which I do
to keep my head straight
(INV-SYSTEM)show user
USER is SYSTEM
(INV-SYSTEM)connect elvis@inv
Enter password: *
Connected.
(INV-SYSTEM)@login
(INV-ELVIS)
or create a script with the login name and sid that calls
(Note: The above URL will get chopped in two pieces by MS Lookout.)
Not only MS Outlook, but in every standard email software.
The length of row is set to 78 (I think it's setting of terminal)
JP
On Tue 26. March 2002 18:13, you wrote:
With a free OTN account:
Peter,
On the NT - the placement of the String/Key values matters. So try setting these
parameters in the Registry in your current '\home' hive under \oracle. For example if
you have a single Oracle Home on your Server/Machine then it would be something like
'home0', so your entries would
Hi
one of export for 35GB database is taking 12 hours.How to reduce this export
time.
Thx
Seema
_
Chat with friends online, try MSN Messenger: http://messenger.msn.com
--
Please see the official ORACLE-L FAQ:
Surprised to not see a backup of the DB and $ORACLE_BASE after #2.
You can combine #3 #4 with find / -user oracle2 -exec chown oracle:dba
{} \; as long as oracle2 is the only member of the dba2 group and you're
not using the oinstall as oracle2's default group.
I think #4 should be -group
Hello everyone,
This is a very interesting thread. Speaking as a part-owner of one of the
companies John held up as an example of the successful outsourcers (thanks
for mentioning us John), I'd like to make some points that I think will be
of interest to all.
The first is that working in a shop
Can someone please create a table for me? Umm...I need last and first name
columns. I don't want the DDL, I want you to connect to my database and
create it for me. I need this done yesterday.
Thanks, really, thanks. Hurry up!!
-Original Message-
Sent: Tuesday, March 26, 2002 11:59
[EMAIL PROTECTED] wrote:
and response time than a well trained DBA can? Fair enough with bug checking
and alike, but how long does it take for a lot of you to get iTARS answered
etc.?
maybe they aren't answering iTARs so they look better delivering it
themselves? see we can do it faster
In fact, here with Oracle 7.3 we had .dbf for data files, .ora for init.ora
file and other config files, and .trc for trace files, .log for log files,
etc.
With the GUI tools introduced with Oracle 8, the extensions were different
-- .ora for everything it seems to me, but I still prefer the
Oracle has been saying for years that you wil no longer need DBAs. I
suppose it's possible, although the database gets more and more
complicated each release, as more and more new features that can shoot
themselves in the foot are added.
On the other hand, SOMEONE will need those DBAs. Oracle?
I have a custom-coded @connect.sql script that I run instead of the build-in
connect statement
HOST chmod 600 /tmp/xxx.sql /dev/null 2/dev/null
SAVE /tmp/xxx.sql REPLACE
CONNECT 1
@login.sql
/bin/rm -f /tmp/xxx.sql /dev/null
UNDEFINE 1
-Original Message-
Sent: Tuesday, March 26, 2002
Create yourself a script called connect.sql that looks like:
connect 1
@@glogin.sql
Keep it in your SQL_PATH just like your glogin.sql. Now when you connect
to something else just precede your connect statement with a @ as in:
@connect un/pw@db02
Can't be much easier than
[EMAIL PROTECTED] wrote:
check sqlplus\admin under ORACLE_HOME
yup, my bad.
--
--
Bill Shrek Thater ORACLE DBA
[EMAIL PROTECTED]
You gotta program like you don't need the money,
You
Are they implying that Oracle Applications is proving too difficult to
administer for many sites?
; )
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
-Original Message-
Sent: Tuesday, March 26, 2002 11:18 AM
To: Multiple recipients of list ORACLE-L
Subject:
Tom,
if he is going to have the tablespace off line with
database up and running , shouldn't the command be
alter tablespace rename file ' ' to ' ' ;
Cheers,
RS
--- Mercadante, Thomas F [EMAIL PROTECTED]
wrote:
Hamid,
.dbf is prefectly valid on all machines, as far as I
know.
You can
Hello All,
Is anyone using HDS's ShadowImage for backing up large databases? Our Sys
Admin Dgmt is pursuing this technique and is suggesting that all large
databases be backed up using this software.
Good? Bad?
Any insights would be appreciated.
My Damager is already crying foul as HDS will
1. Is the critical data would be updated in the sites..?
Yes...
2. If yes , are you expecting the other sites to 'see' this update...?
Yes...
3. If one site is down, then are you expecting the other sites to share
the load or you have the closest site in take in all the load...?
Yes
but add
I think you can use direct=y option.
Are you taking this export to a file (over disk) or directly to tape?
Greeting
Diego Cutrone
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Tuesday, March 26, 2002 3:13 PM
Hi
one of export for 35GB
How do you know you ran the login script?? Maybe you forgot? And your
really on production...when your about to truncate that table...that's
unrecoverable...that's billions of rowswith hundreds of recent Fairfield
customer reservations...that will be very upset...
BTW, any chance you can
From what I understand, the task is daunting keeping a release up to date.
They've really built a beast. When you hear people on this list talking
about APPS DBA's, you get the feeling that it is something special.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent:
Well,
being in health care industry myself I know too well
what do you mean. Apart from 100s of tousands of $
lost every hour we are down, we have to take some
safety also into account.
As to the question of advanced replication, having
implemented multi-master replication myself I know
what a
You don't. It's a habit you have to get into. And it only works if you
haven't changed your directory. Like I said you can have another script
that has login commands
(INV-SYSTEM)@elvis
Enter password: *
Connected.
(INV-ELVIS)
My @elvis script is simply this
connect elvis@inv
@login
I
Can someone point me to good reading material on this
subject. Is one better than the other for performance
and manageability?
Syntactically the autoallocate is shorter and seems to
be more hands off (does that mean worry free also?).
TIA
=
Sundeep Maini
Consultant
Currently on
And do you expect a link or a real example script???
On Tue 26. March 2002 19:29, you wrote:
Can someone please create a table for me? Umm...I need last and first name
columns. I don't want the DDL, I want you to connect to my database and
create it for me. I need this done yesterday.
I think that this is a marketing ploy by Oracle, much like the DBO
(and frankly to a lesser degree the OCP) in an effort to deal with
the simple supply/demand problem with Oracle DBA's. Somehow, the tag
line on my emails seems to apply here... :-)
Robert G. Freeman - Oracle8i OCP
Oracle DBA
ok it's done. check your database. I also populated it with all the URL
links to child-porn. the FBI is knocking at your door right now. check the
BLOB columns. pretty nasty stuff stored there.
-Original Message-
Sent: Tuesday, March 26, 2002 1:29 PM
To: Multiple recipients of list
Oracle Wants Users to Hand over Apps Management = Oracle Wants Users to Hand over
Money.
Jerry Whittle
ACIFICS DBA
NCI Information Systems Inc.
[EMAIL PROTECTED]
618-622-4145
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Whittle Jerome Contr NCI
INET: [EMAIL
Get out the BS bingo cards..
;o)
-Original Message-
Sent: Tuesday, March 26, 2002 12:09 PM
To: Multiple recipients of list ORACLE-L
Rocheste
Hello everyone,
This is a very interesting thread. Speaking as a part-owner of one of the
companies John held up as an example
It used to be better, when we could just call them. We used to have silver
support.
Then, at first, Web TARs were answered promptly.
I don't know if there has been a change in policy, but as soon as it's past
regular hours I get little feedback from Metalink technicians.
They used to have a
In a sociology course I took they explained that capitalism and publicly
traded companies naturally tend toward oligopolies, followed by monopolies.
Not sure if that is true - I was hoping the antitrust laws would prove
useful, but...
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified
do this:
exp usr/pass buffer=4096 file=xx log=xx owner=xx. It takes 2 hours for
a 59GB's database.
-Original Message-
Sent: Tuesday, March 26, 2002 12:13 PM
To: Multiple recipients of list ORACLE-L
Hi
one of export for 35GB database is taking 12 hours.How to reduce this export
Make sure you didn't issue consustent=y and refer to
meta link for any problems with direct export on your
platform. Direct is the way to go.
Cheers,
RS
--- Diego Cutrone [EMAIL PROTECTED] wrote:
I think you can use direct=y option.
Are you taking this export to a file (over disk) or
1 - 100 of 179 matches
Mail list logo