RE: Generic Import question
Date: Thu, 6 Sep 2012 12:16:46 +0000
Message-ID: <33B09BA255BD7142B217C2C0A0D0183406B9040E_at_DCSOSVMS02.dcso.org>
I'm moving from 9ix32 bit world over to 11gx64bit world and I'm modifying some storage and object structures.
Yea, schemas are smallish (whole DB is only about 80g).
-----Original Message-----
From: De DBA [mailto:dedba_at_tpg.com.au]
Sent: Tuesday, September 04, 2012 7:23 PM
To: Storey, Robert (DCSO)
Cc: oracle-l_at_freelists.org
Subject: Re: Generic Import question
My worry with a full import would be that it may import 9i data dictionary data that would be deleted during a proper upgrade. You'd probably have to run the upgrade scripts after a full import to ensure that that doesn't happen, but where's the guarantee that you end up with a clean upgraded 11g dictionary after that?
If you plan to import the 9i data dictionary into your 11g database, why wouldn't you just copy the database (or restore a backup) and upgrade it? Seems cleaner to me..
I'd go with the schema import, and create synonyms, directories, vpds etc. as required if the schemas are smallish.
Cheers,
Tony
On 5/09/12 3:09 AM, Storey, Robert (DCSO) wrote:
> Working on moving a 9i database over to 11g. I can easily do a full import to bring everything over, but, I only have 4 schemas that contain my application tables and such.
> So, what is the benefit of doing a full import vice just the schemas? I had planned to precreate the storage structures and the 4 schema owners.
>
> Just curious.
>
> Thanks
> Bob
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>
>
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Sep 06 2012 - 07:16:46 CDT