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