Re: Generic Import question

From: Guillermo Alan Bort <cicciuxdba_at_gmail.com>
Date: Tue, 4 Sep 2012 14:35:56 -0300
Message-ID: <CAJ2dSGQTmQY0y=06QOMHUW-P2DonW6enczYKj-zn4g2FuYRL5g_at_mail.gmail.com>



My first thought is this:
Are you 100% you only need those schemas? What about public synonyms? what about password verify functions? Profiles? resource groups?. basically what about all the configurations that are not part of schemas? (i.e. are stored under sys)
Cheers
Alan.-

On Tue, Sep 4, 2012 at 2: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.
>
> Just curious.
>
> Thanks
> Bob
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Sep 04 2012 - 12:35:56 CDT

Original text of this message