RE: Annoying full export full import
- From: "Boivin, Patrice J" <BoivinP@xxxxxxxxxxxxxxxxx>
- To: "'oracle-l@xxxxxxxxxxxxx'" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 29 Jul 2004 13:44:51 -0300
I had a "discussion" with Oracle Support on import dropping objects
referring to invalid db links.
During an upgrade to 8i years ago, one of the servers our db links pointed
to was assigned a new IP address at the same time we were doing the upgrade.
Result: Missing objects.
Oracle Support informed me that this is expected behaviour, we're not
supposed to have invalid db link pointers in our database...
Patrice.
-----Original Message-----
From: Paula_Stankus@xxxxxxxxxxxxxxx [mailto:Paula_Stankus@xxxxxxxxxxxxxxx]
Sent: July 29, 2004 1: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 //www.freelists.org/archives/oracle-l/
FAQ is at //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 //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
