Hi,
Suse7.2 is certified with 9.0.1. It will never be certified with 9.2 and
later versions. Suse has a special product SLES - Suse Linux Enterprise
Server. It's based on Suse 7.2 and include many official patches and
upgrades.
Afaik, with Suse 7.2 you may not upgrade your kernel and be certified
Why are you including -0.870?? In that case you should also include -.880.
I think theoretically there is nothing right or wrong about rounding thing.
You have to decide upon one way and follow that universally.
Naveen
-Original Message-
Sent: Thursday, August 29, 2002 10:19 PM
To:
We are using TOAD for the DBA team.
For the developers we got PlSqlDeveloper and it works fine.
You can check also www.quest.com for the new sql editor that they developed
recently.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent:
Hi
if you include -0.870, you should also include -0.880 in which case the
split will go 6:5 either way you choose.
Jack
kkennedy
If you specify a hint Oracle is forced to use the index.
Your hint's syntax is wrong. USE - /*+ INDEX(test index_a) */
Don't use the comma *** between the table name and the index name
Naveen
-Original Message-
Sent: Friday, August 30, 2002 12:33 PM
To: Multiple recipients
Chuan Zhang,
hei£¬you statement choose all rows from the table,Of course oracle will use full
table scan!
There is no where clause in your SQL.If you add:
select a,b,c from test where a=some_value, then of course it will use the
index.
Regards
zhu chao
Hi all,
Is there something like,
unix is unable to use commands like ls -ltr (sort etc)
when there are huge number of files in a directory(may
be thousands/millions).
If yes, what is the limit and how to know it on sun
solaris 2.8.
thnx and regards,
srinivas
--- Lakhani, Vipul [EMAIL
hi
we use on sunos 5.8 the same scripts as on linux - as we use on all
*nices the bash.
kr mr
[EMAIL PROTECTED] 08/29/02 21:46 PM
Hi
Does some one have DB down script on Sun solaris.I mean to say if
instance
down I will get page .
Thx
-Seema
Title: Configuring 734 and 817 on same machine.
Hello Gurus,
Does anyone have a link to a resource which describes the Installation and configuration of Oracle 734 and Oracle 817 on the same Windows 2000 machine.
The configuration of the listeners is my main concern.
Any help on this is
oraora oraora,
If you want to implement TAF, you have to use OPS/RAC. and you application
must be written via OCI when connect to database. For standby to be in recover, it
take some minutes to recover the final redo log from the primary site, which maybe
need human interaction.
I have several Suse 7.2 running fine with ReiserFS and Ext2.
Recently, I've got a problem with RAM (hanging several times) I have changed
the ram, but yesterday I have found a couple of corrupted blocks in one
database, so I guess memory could possibly be an issue. Are there any other
negative
Title: RE: Re:RE: Re[2]: controlling CPU usage through Oracle
Patrice,
I
think I posted this not so long ago but I have this one and it works.
Regards HTH
Lee
/***//*
*//* Author: Lee
Robertson
*//*
*//* Title:
killsession.sql
Hi,
My guess would be (from memory)
Install Oracle 7 first because it wants to be in the first Oracle home
than 8i and configure the listener of 8i to listen for all database
connections on the machine.
I once tried to install Oracle 7 after I had installed 8i and had to fiddle
with the
In NT and win2000 you can set Os priorities to the different tasks.
If you have the sane facility on aix you can give this db a lower priority
so whenever the other databases will need CPU they will get it.
Yechiel Adar
Mehish
- Original Message -
To: Multiple recipients of list ORACLE-L
Title: RE: Re:RE: Re[2]: controlling CPU usage through Oracle
very
funny, but I asked because sometimes developers create 'zombies' on our UNIX
server.
Why
would being chained to a desk that is connected to Oracle be punishment? I
don't understand...
; )
Regards, Patrice Boivin Systems
I read something about Oracle on Windows not being able to extend past the
2G limit, but haven't verified.
I believe it has to do with Oracle on Windows, not windows or hardware.
Regards,
Patrice Boivin
Systems Analyst (Oracle Certified DBA)
Systems Admin Operations | Admin. et Exploit. des
Does that mean you didn't get my email about presenting my rman paper?
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 29, 2002 7:47 PM
the [EMAIL PROTECTED] email addy has evidently been sent on to spam
lists, i'm getting
Hey all,
While reviewing our annual maintenance agreement ($5,000) and considering an
additional $30K license purchase, our savvy network admin suggested we look
into Oracle's Partner Network. After some research, phone conversations,
and pouring through the license agreement with a fine-tooth
hahahah, now thats a kewl domain.
joe
Post, Ethan wrote:
I would but I got to put some money down on www.phatdba.com
Ethan Post
perotdba (AIM), epost1 (Yahoo)
-Original Message-
Sent: Thursday, August 29, 2002
Bingo. It was the grants, as I had tried w/o indexes/constraints. There
were some 1800+ grants per table. With grants set to no, an import which
creates constraints and indexes is flying.
It has been so long since I worked with a product where each user is given
direct grants rather than thru
On
Oracle8i Enterprise Edition Release 8.1.7.2.0 - 64bit Production
PL/SQL Release 8.1.7.2.0 - Production
CORE8.1.7.0.0 Production
TNS for Solaris: Version 8.1.7.2.0 - Production
NLSRTL Version 3.4.1.0.0 - Production
I got a stange result and I wish to find an explanation.
Look
I did
At 09:43 AM 8/29/2002, Manavendra Gupta wrote:
I'm sure there has been discussion in the past about the same, but I'm
more interested in the feasibility/performance of serving images (stored
as BLOB) from the database.
Is there a reason that you're not using interMedia here? interMedia is
Yes, you are right. I forgot to mention monitoring,
On 2002.08.30 01:23 Khedr, Waleed wrote:
Or when you are done moving these suspected indexes to a new Tablespace,
you can monitor the read/write statistics for the files in that Tablespace
(v$filestat).
Another idea is to put the
At 02:33 AM 8/30/2002, you wrote:
oraora oraora,
If you want to implement TAF, you have to use OPS/RAC. and you
application must be written via OCI when connect to database.
Your application doesn't necessarily have to be written in OCI to use TAF,
but whatever layer eventually
Title: RE: Re:RE: Re[2]: controlling CPU usage through Oracle
I
quite agree with Patrice - and what's more, 'zombies' is the exact right word
for them !
peter
edinburgh
ps - I
did get a laugh out of the exchange too
-Original Message-From: Boivin, Patrice J
Thanks Rachel.
I spent the train ride reading the chapters on Instance Tuning and Dynamic Performance
Views hoping to find something, but no such luck. I learned a lot of other useful
things though, so it wasn't a waste of time.
Jacques, v$locked_object shows the table, but I already knew
Unix scripts is one thing I don't worry much and am taking my own time to
learn those with Perl. We got a fantastic bunch of Unix admins who are just
waiting for challenges and always deliver.
It is bad (for me) and good (that I can spend more time on Oracle issues
like chasing OWS personnel and
My point was that in the corporate world, there is little choice.
The only viable software choice is Outlook on WinNT boxes.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Thursday, August 29, 2002 6:39 PM
To: Multiple recipients of list ORACLE-L
No, I'm not
It was a bug on windows - with auto extend on and crossing 4Gb filesize.
-Original Message-
Sent: Friday, August 30, 2002 6:58 AM
To: Multiple recipients of list ORACLE-L
I read something about Oracle on Windows not being able to extend past the
2G limit, but haven't verified.
I
Hi,
I've run across an anomaly while updating
statistics. It appears that the sample size specified by the analyze
statement is not producing the results I'd hoped for. By my calculations,
the 5% estimate has a sample size of 1%, the 10% uses 1.6%, and the 40% uses 5%.
Are there any known
We are OPN members - we have one database for our internal use and pay full
price for it and support. In addition we have a bunch of purely development
databases - on differing platforms (linux, solaris) that we download and use
for no additional fee's.
-Original Message-
Sent: Friday,
I created following two views for developer's use and so far there have been
no complaints ..
CREATE OR REPLACE FORCE VIEW SYSTEM.DB$LOCKED_OBJECTS
(OBJECT_NAME, SESSION_ID, ORACLE_USERNAME, OS_USER_NAME, SQL_ACTIONS,
LOCK_MODE) AS
SELECT DO.object_name, lo.SESSION_ID, lo.oracle_username,
Bernard
I think this may be a bug in early versions of 8.1.7. I don't know the
number, but I had a similar problem recently. Its to do with whether the
query is scanning an index or not. Try forcing the query to do a full scan:
-
SQL select /*full(ced_info_mouvement)*/ count(*) from
Rebuild your index and try again
-Original Message-
Sent: Friday, August 30, 2002 6:53 PM
To: Multiple recipients of list ORACLE-L
?
On
Oracle8i Enterprise Edition Release 8.1.7.2.0 - 64bit Production
PL/SQL Release 8.1.7.2.0 - Production
CORE8.1.7.0.0 Production
TNS for
MVT_ID_LOT_IDX is corrupt? Does rebuilding the index fix the problem?
-Original Message-
Sent: Friday, August 30, 2002 9:23 AM
To: Multiple recipients of list ORACLE-L
?
On
Oracle8i Enterprise Edition Release 8.1.7.2.0 - 64bit Production
PL/SQL Release 8.1.7.2.0 - Production
CORE
-- Pawan Dalmia [EMAIL PROTECTED]
My var partition is 99% full of which there are lot of files in /var/tmp
directory.
Can i delete this files ?
Probably. Older ones are a better bet:
cd /var/tmp;
find . -atime +7 -type f | xargs rm -f;
Question is what job leaves files behind
Oracle 8.1.6/WinNT
I get ora-1017 invalid username/password when trying to
connect as internal. I have recreated password file many
times to no avail. Usually this all I have had to do in the
past for this error. I have tried all combinations of
remote_login_passwordfile. I was
Next question is, how did this happen?
ltiu
Mercadante, Thomas F wrote:
My point was that in the corporate world, there is little choice.
The only viable software choice is Outlook on WinNT boxes.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Thursday,
-- kommareddy sreenivasa [EMAIL PROTECTED]
Hi all,
Is there something like,
unix is unable to use commands like ls -ltr (sort etc)
when there are huge number of files in a directory(may
be thousands/millions).
If yes, what is the limit and how to know it on sun
solaris 2.8.
This is
Er.
You can use roles in Oracle as well?
Cheers
Nuno Souto
[EMAIL PROTECTED]
- Original Message -
It has been so long since I worked with a product where each user is
given
direct grants rather than thru a role, that I forgot that it was
possible to
have that many grants on a
oh no, you can always use Lotus Notes with W2K, XP or NT... we are here
such lovely choices we have
--- Mercadante, Thomas F [EMAIL PROTECTED] wrote:
My point was that in the corporate world, there is little choice.
The only viable software choice is Outlook on WinNT boxes.
Tom
Not all Oracle API's support TAF. I know that the JDBC thin driver does
not support TAF, while the JDBC OCI driver does.
Brian
--
| Brian McGraw /* DBA */ Infinity Insurance |
| mailto:[EMAIL PROTECTED] |
The size of the buffer used to store parameters is actually
configurable in most Unix versions I've had a look at.
Somewhere around 4K, from memory. Would be very surprised
if it wasn't configurable in Solaris. Would also be very
surprised if you find one techo at Sun that knows how to
There was a bug (still is in 8?) in 7.3 where a parallel index creation
would cause an index to be built with 0 entries. This would occur when the
index columns could be found in another index. The parallel master process
would get confused as to which index was the source and target. The end
Title: RE: IMPORT sl
i might add my 2c, even though the problem has been resolved. :-)
once upon a time, we had a 2g database that was taking a looong time to import. anyone ever heard of remedy?
did everything that has already been mentioned.
tracing revealed log file sync
found some way to fake out Linux to run Lotus Notes in a shell if I am not
mistaken, too...
-Original Message-
Sent: Friday, August 30, 2002 9:49 AM
To: Multiple recipients of list ORACLE-L
oh no, you can always use Lotus Notes with W2K, XP or NT... we are here
such lovely choices we
Wine can run lotus notes. I tested it and it works fairly nice. The only
problem is that I cannot resize the window, so I have to use another
workspace
for it.
-Original Message-
From: April Wells [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 30, 2002 11:29 AM
To: Multiple
The universe exists according to our beliefs. If you believe that you have
no choice, then you have no choice. But only because you believe it.
Happy Friday,
Mark There is no spoon Stahlke
Denver Newspaper Agency
-Original Message-
Sent: Friday, August 30, 2002 7:58 AM
To:
I had the same issue in a 8.1.6 database and found that was bug related to
the cost based optimizer and materialized views. Never did resolve it but
found that the problem occurred when the table in question had a
materialized view selecting data from in.
Thanks,
caj
- Original Message
Title: RE: IMPORT sl
I like the way you found the root cause. If
I may paraphrase, you asked the database how it was spending its time, and the
answer guided the remainder of your performance improvement project. I contrast
this method with the traditional approach, which is to
Good morning, everyone.
A running Oracle server contains both library cache locks and library
cache latches. What are the criteria for using a lock vs. a latch for
protecting objects in the cache? For example, at the moment we're
trying to create a new version of a package, but a running
Lotus Notes is good enough and for a time were the number one (and the only
one). How the hell did they lose market share?
ltiu
On Friday 30 August 2002 08:28, April Wells wrote:
found some way to fake out Linux to run Lotus Notes in a shell if I am not
mistaken, too...
-Original
I need to create the Scott/Tiger schema in Oracle9i. Does anyone
recall off the top of their head just where the script to do this is
located?
Jonathan Gennick --- Brighten the corner where you are
mailto:[EMAIL PROTECTED] * 906.387.1698
http://Gennick.com * http://MichiganWaterfalls.com *
Anyone else hear that SQL*Plus is going away in 10i??
RF
Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author
Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
Oracle9i New Features (Oracle Press)
Mastering Oracle8i (Sybex)
The
On Mon, 26 Aug 2002 13:41:50 -0800, Rachel wrote:
I am not, by any means, a SQL*Loader expert (Jonathan, I keep meaning
to get your book!)
Sounds like you've solved this one already, but since you invoked my
name (and in vain too, since I was of no help grin), I'll just chime
in to say that my
Hi All,
I have a system with 2 databases, both running on the same server 8.0.5.
OS - Windows NT
When i connect thru server manager to TEST, and then issue STARTUP, it starts
up the PROD database using the initPROD.ora file.
On querying V$instance it shows INSTANCE_NAME = TEST
On querying
Here's a ksh script that dumps backup files to a remote server. It also
accounts for multiple datafiles per tablespace, which I didn't see coded
in the Velpuri scripts.
Suzy
#!/bin/ksh
#
HERE... herd mentality... Microsoft rules... Microsoft Rules... Oracle
Applications are buggy and user GMT in their log files... Access is better,
Microsoft doesn't sell buggy software... mooo... hey... look at that really
cool cliff... Let's follow those other buffalo ... the jump looks like
Someone had asked this question ... maybe this will help ..
Batch mode report generation
To run a report without being prompted, assign values to the
and the report name before running spreport.
The variables are:
begin_snap -
I don't know about the user scott/tiger, but the scripts to build the tables
(emp, dept, etc) are in $ORACLE_HOME/sqlplus/demo
/opt/oracle/product/9.0.2/sqlplus/demo ll
total 16
-rw-r--r-- 1 oracle oinstall 3565 May 13 2001 demobld.sql
-rw-r--r-- 1 oracle oinstall 573 May
Are you kidding? So what do we use to startup and shutdown db? OEM?
I don't think there is any truth to this one.
Richard
-Original Message-
Sent: Friday, August 30, 2002 12:23 PM
To: Multiple recipients of list ORACLE-L
Anyone else hear that SQL*Plus is going away in 10i??
RF
The same way Digital did. The best product doesn't always win...
-Original Message-
Sent: Friday, August 30, 2002 12:19 PM
To: Multiple recipients of list ORACLE-L
Lotus Notes is good enough and for a time were the number one (and the
only
one). How the hell did they lose market
$ORACLE_HOME/rdbms/admin/utlsampl.sql
Jonathan Gennick [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
08/30/2002 09:53 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Creating Scott/Tiger
I need to
EXCELLENT! This is EXACTLY what I was looking for. Thank you very much!
Erik
-Original Message-
Sent: Friday, August 30, 2002 1:33 PM
To: Multiple recipients of list ORACLE-L
Someone had asked this question ... maybe this will help ..
Batch mode report generation
How do they expect you to start and stop the database if it goes away?
and please don't say OEM...
--- Freeman, Robert [EMAIL PROTECTED] wrote:
Anyone else hear that SQL*Plus is going away in 10i??
RF
Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database
Nooo!!!
On Friday 30 August 2002 09:23, Freeman, Robert wrote:
Anyone else hear that SQL*Plus is going away in 10i??
RF
Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author
Oracle9i RMAN Backup and Recovery (Oracle Press - Oct
Check init.ora parameter,remote_login_passwordfile should be exclusive.
regards,
---
Atin Kumar Jain
OCP 8i DBA
IBM Global Services
SO Jamshedpur
0657- 424478,147074
[EMAIL PROTECTED]
[EMAIL PROTECTED]
Ruth, i got it as i've not file 13'd the email acct yet.
thanks, joe
Ruth Gramolini wrote:
Does that mean you didn't get my email about presenting my rman paper?
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, August 29, 2002 7:47
I've been sampling active SQL at a rate of 5 Hz and saving the wait information to a
table. Here is one example.
SELECT RUNDATE, EVENT, SECONDS_IN_WAIT, STATE, SEQ#
FROM STATEMENT_WAIT_INFO WHERE USERNAME = 'ARF' AND
ADDRESS = '8992E2C8' AND HASH_VALUE = 3642756738
RUNDATE
I find that the worst problems I have with SQL*Loader tend to be
language related. The same goes with export/import. I wish there were
better documentation on the NLS parameters.
and yes, it was characterset. What I didn't understand was why when I
selected from NLS_DATABASE_PARAMETERS it showed
Hi Jonathan
I need to create the Scott/Tiger schema in Oracle9i. Does anyone
recall off the top of their head just where the script to do this is
located?
The creation script can usually be found in
${ORACLE_HOME}/sqlplus/demo/demobld.sql
Regards
Dale
--
Need instant
Yes, Oracle will sell it as standalone product because it is most useful and
most used client software on Oracle. The licence model is 'per session'.
:-)))
BTW: Anybody's using gqlplus?
http://gqlplus.sourceforge.net/
JP
On Friday 30 August 2002 18:23, you wrote:
Anyone else hear that
oradim -startup -sid sid -pfile pfile_path ???
They got rid of SVRMGR.
ltiu
On Friday 30 August 2002 11:08, you wrote:
How do they expect you to start and stop the database if it goes away?
and please don't say OEM...
--- Freeman, Robert [EMAIL PROTECTED] wrote:
Anyone else hear that
Nope.
-Original Message-
Sent: Thursday, August 29, 2002 7:47 PM
To: Multiple recipients of list ORACLE-L
If you can't do it in hardware, do it in software. Right?
ltiu
Ji, Richard wrote:
There is no such hardware limitation like that. Those are the OS i.e.
software limitations.
Just my guess, look at the registry parameter ORA_SID_PWFILE(Sorry my
knowledge is limited to NT only) and see if it is pointing to the right file.
Try restarting the service.
Are you running more than one DB on the same server?
by the way, if you find out the exact reason why this is happening
We only need to start it. It usually stops itself without human control.
That is why we have ora-600 and ora-7445 features implemented in PMON
and SMON. As for starting and stopping, let me be innovative:
What do you say to call the start/stop program IOR and have
database startup performed
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Denis Vasconcelos
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
What would be the replacement??
-Original Message-
Sent: Friday, August 30, 2002 11:23 AM
To: Multiple recipients of list ORACLE-L
Anyone else hear that SQL*Plus is going away in 10i??
RF
Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Hi,
I am trying to put together a package that uses the AUTHID current_user
directive to decide whether to let people kill a session or not, and I ran
into a problem.
One procedure will run as SYS, but I need to double-check the requester's
username to ensure he/she isn't trying to kill their
oradim is only a windows thingy. Those of us on real OS's use svrmgrl or sqlplus depending on version. Are you saying that they are going to port oradim to *NIX??
Rodd
On Fri, 2002-08-30 at 13:33, ltiu wrote:
oradim -startup -sid sid -pfile pfile_path ???
They got rid of SVRMGR.
Title: Missing Redo Log Files and Control File
Hi,
We were almost done setting up a new server for the developers when a hard drive crashed. MTBF sure took a hit on that one! We had a replacement drive installed.
Fortunately we really only lost a control file and redo logs on that disk
Thanks Raj.
I'll give these a try.
--
Alan Davey
[EMAIL PROTECTED]
212-604-0200 x106
On 8/30/2002 10:08 AM, Jamadagni, Rajendra [EMAIL PROTECTED] wrote:
I created following two views for developer's use and so far there
have been
no complaints ..
CREATE OR REPLACE FORCE VIEW
Hi All,
i am starting to feel real dumb, have RTFM for oracle utilities on imp/exp 3
times but don't seem able to get the imp to just load the data and not the
tables as well. Am running solaris 8 oracle 8.1.7 anything that i might
not be seeing would be very much appreciated!!
Connected to that, there is a rumor tha M$ will buy
Oracle Corp., with
Larry
Ellison taking the place of Steve Ballmer.
-Original Message-From: Rodd Holman
[mailto:[EMAIL PROTECTED]]Sent: Friday, August 30, 2002 3:24
PMTo: Multiple recipients of list ORACLE-LSubject: Re:
Naveen,
If you specify a hint Oracle is forced to use the index.
Not 'forced'. Hence the name 'hint'.
--
Regards,
Stephane Faroult
Oriole Software
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Stephane Faroult
INET: [EMAIL PROTECTED]
Fat City Network
Absolutely
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Thomas Day
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
thats the Stupid WINDOZE way.
joe
ltiu wrote:
oradim -startup -sid sid -pfile pfile_path ???
They got rid of SVRMGR.
ltiu
On Friday 30 August 2002 11:08, you wrote:
How do they expect you to start and stop the database if it goes away?
and please don't say OEM...
--- Freeman, Robert
Why not? It's easy to use. It will increase Oracle's market share to the dumb
and dumber.
ltiu
On Friday 30 August 2002 12:24, you wrote:
oradim is only a windows thingy. Those of us on real OS's use svrmgrl
or sqlplus depending on version. Are you saying that they are going to
port
My understanding is that 8.1.7.3 is the buggy one. It was supposed to be
the terminal 8.1.7 release but it had so many problems they had to come out
with 8.1.7.4
-Original Message-
Sent: Thursday, August 29, 2002 5:44 PM
To: Multiple recipients of list ORACLE-L
DBA's
I have to
Rumor ...
They might as well buy SUN along the way (and get rid of Java for good).
SUN's market cap is only $13B. MS got $300B.
On Friday 30 August 2002 12:44, Gogala, Mladen wrote:
Connected to that, there is a rumor tha M$ will buy Oracle Corp., with
Larry Ellison taking the place of Steve
Bill,
I assume from the way you state this, you already have the tables built and
don't want imp to blow up trying to recreate them. Correct? If so, try
ignore=y. Also, if the user is changing, are you using fromuser= touser=?
Output from your problem might be helpful.
HtH,
John P
Alan Davey wrote:
Thanks Rachel.
I spent the train ride reading the chapters on Instance Tuning and Dynamic
Performance Views hoping to find something, but no such luck. I learned a lot of
other useful things though, so it wasn't a waste of time.
Jacques, v$locked_object shows the
Bill
Ignore=Y is that what you're looking for?
Mike
-Original Message-
Sent: Friday, August 30, 2002 3:44 PM
To: Multiple recipients of list ORACLE-L
Hi All,
i am starting to feel real dumb, have RTFM for oracle utilities on imp/exp
3
times but don't seem able to get the imp to just
just throw it out on ebay for auction Joe! :-)
Robert G. Freeman - Oracle OCP
Oracle Database Architect
CSX Midtier Database Administration
Author
Oracle9i RMAN Backup and Recovery (Oracle Press - Oct 2002)
Oracle9i New Features (Oracle Press)
Mastering Oracle8i (Sybex)
The avalanche has
I assume that the schemas, tables, synonyms, roles, grants, etc already
exist and you just want to populate the tables with the data from your
other database.
In your parm file set IGNORE=Y. This will ignore errors caused by already
created objects and just load the data.
Type: imp help=y
to
BTW: Anybody's using gqlplus?
Whoa, I've been looking for something like this. Is it any good?
-Original Message-
Sent: Friday, August 30, 2002 12:28 PM
To: Multiple recipients of list ORACLE-L
Yes, Oracle will sell it as standalone product because it is most useful and
most used
Bill,
Where are you trying to load the data to? Do the tables already exist? If
so, then use the ignore=y option and it won't complain if the table already
exists when it tries to create it, but it will load the data into it.
Bill Conner wrote:
Hi All,
i am starting to feel real dumb,
Speaking of the recursion, now 8.1.7.4 has some serious problmes,
especially on HP-UX 11/64 with OPS.
-Original Message-
From: Miller, Jay [mailto:[EMAIL PROTECTED]]
Sent: Friday, August 30, 2002 3:58 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: upgrade 8.1.6.2 to
1 - 100 of 143 matches
Mail list logo