RE: Generic Import question

From: Storey, Robert (DCSO) <"Storey,>
Date: Tue, 4 Sep 2012 17:37:05 +0000
Message-ID: <33B09BA255BD7142B217C2C0A0D0183406B901D7_at_DCSOSVMS02.dcso.org>

Its not an existing per say. I'm creating the 11gdb to support the app and migrating the 9i data over.

But, that's my thinking as well. Unless I'm missing some script I should run after the import or such.

-----Original Message-----
From: rjamya [mailto:rjamya_at_gmail.com] Sent: Tuesday, September 04, 2012 12:36 PM To: Storey, Robert (DCSO)
Cc: oracle-l_at_freelists.org
Subject: Re: Generic Import question

If you are bringing your app into existing 11g db, why do full import? sys and related schemas are already properly upgraded, I'd just bring in your app schemas. That should do it.

Raj

On Tue, Sep 4, 2012 at 1:09 PM, Storey, Robert (DCSO) <RStorey_at_dcso.nashville.org> 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.

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Sep 04 2012 - 12:37:05 CDT