Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Annoying full export full import

RE: Annoying full export full import

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Thu, 29 Jul 2004 13:11:00 -0400
Message-ID: <564DE4477544D411AD2C00508BDF0B6A2133DE36@usahm018.exmi01.exch.eds.com>


Grants by SYS have always been lost via exp/imp. After you run catalog and catproc on a new DB that you intend to import into you should consider creating the owning users and running a script to re-issue the grants from SYS. Then when you run your import you will avoid this problem.

You should also pre-create any desired database links for similar reasons.

And I will point out that grants by SYS can be lost with upgrades that require rerunning catalog and catproc so having a granted_by_sys.sql script handy is part of our upgrade procedure.

IMHO -- Mark D Powell --

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of 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

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US