| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Annoying full export full import
I remember having all sorts of problems in the past (can't remember if it was
version 7 or 8) with functions and procedures containing private db links.
Evidently 'BECOME USER' couldn't deal with the private links. Not only were the
imported objects invalid, but they needed to be recreated. I avoided this by
adding dummy public db links (pointing at the source database) with the same
name as the private links. The objects still imported as invalid, but only
needed a recompile to change their status. I haven't looked at this issue in a
long time so I don't know if it is still a problem.
Henry
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Mercadante, Thomas F
Sent: Thursday, July 29, 2004 1:13 PM
To: 'oracle-l_at_freelists.org'
Subject: 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_at_doh.state.fl.us [mailto:Paula_Stankus_at_doh.state.fl.us]
Sent: Thursday, July 29, 2004 12:24 PM
To: oracle-l_at_freelists.org
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
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.htmlput 'unsubscribe' in the subject line.
-----------------------------------------------------------------
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request_at_freelists.org
 |
 |