RE: Annoying full export full import

From: Mercadante, Thomas F <thomas.mercadante_at_labor.state.ny.us>
Date: Thu, 29 Jul 2004 13:13:03 -0400
Message-ID: <DE8A21F8F1D0254EA4A9214D52AB2FED11F2C003@exchsen0a1ma>

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

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org 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_at_freelists.org

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

Received on Thu Jul 29 2004 - 12:09:48 CDT