RE:Annoying full export full import

Isn't it due to the underlying tnsnames file being incomplete and not due 
to the db links themselves not being there ? Ran into the exact same thing 
myself recently during an exp/imp upgrade from 8.0.5 (!) to 9.2.0.4 
(management wanted to use the exp/imp route to have a fallback scenario, 
i.e. revert back to the 8.0.5 in case of disasters).

mvg/regards

Jo






Paula_Stankus@xxxxxxxxxxxxxxx
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
07/29/2004 18:23
Please respond to oracle-l

 
        To:     oracle-l@xxxxxxxxxxxxx
        cc: 
        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: