RE: Annoying full export full import

Paula,

I think your guess about the full export being run under SYS is probably
correct.

But, I always create tablespaces, roles, users, db links, and grants to sys
objects before I perform an import.  I've just learned that these things
either don't come across correctly, or I get the stupid import errors.

I'd rather be safe than sorry.

Tom Mercadante
Oracle Certified Professional


-----Original Message-----
From: Paula_Stankus@xxxxxxxxxxxxxxx [mailto:Paula_Stankus@xxxxxxxxxxxxxxx] 
Sent: Thursday, July 29, 2004 12:24 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE:Annoying full export full import


Doing a full export from 8.0.6 to import of 9.2.0.4 you would think that =
dependencies would be handled correctly.

I found out however that views were created (not even showing up with a =
definition and an invalid status) due to database links not being there. =
However, the import did do database links at some point.  I am running = the
import a second time with rows=3Dno hoping to save myself some time.

I thought all permissions are granted/handled through full = export/import.
However, a number of permissions to sys. objects were = not.  That must be
because I ran the full export/import as system - = right?  If I had run it
under "sys" then that wouldn't have happened = because the permissions would
be there? =20

Any suggestions for a cleaner full export/import between 8.0.6 and =
9.2.0.4?

Thanks,
Paula
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx put
'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: