RE: Generic Import question

  • From: "Storey, Robert (DCSO)" <RStorey@xxxxxxxxxxxxxxxxxx>
  • To: 'rjamya' <rjamya@xxxxxxxxx>
  • Date: Tue, 4 Sep 2012 17:37:05 +0000

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@xxxxxxxxx] 
Sent: Tuesday, September 04, 2012 12:36 PM
To: Storey, Robert (DCSO)
Cc: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxxxxxxx> 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.
--
//www.freelists.org/webpage/oracle-l


Other related posts: