Re: Export dictionary managed and import to locally managed.
Date: Fri, 5 Mar 2010 16:00:29 -0800 (PST)
On Mar 5, 1:23 pm, bontemps <jontan_..._at_yahoo.com> wrote:
> We are upgrading our vendor supplied application which requires a new
> server and an oracle upgrade. Production data is all contained in a
> single schema and dictionary managed user tablespace. I was hoping we
> could create a new 11g database and a locally managed user tablespace
> with system managed extent sizing AND use export/import to move the
> data. Is this possible? Will Oracle want to create the objects in
> new database just as they were exported?
Not only possible, but a good idea. Just create users and tablespaces before the import and do a schema level export, import with ignore =y. The defaults tend to be ok unless you have some strange app, whereas other methods like upgrading in place will just leave any old problems in place. You may want to adjust pctfree on certain tables if you have a bunch of old data that you won't be updating, then change it for new data, but just give it a try with defaults and see if data sizes change. Autoallocate works pretty good if you have a mix of table volatility and size.
You may also need a full rows=N export for some objects, depending on your app and data.
Further advice may be forthcoming if you happen to mention the version you are coming from, and platforms.
-- _at_home.com is bogus. http://www.fakesteve.net/2010/03/yelp-still-keeping-it-classy.htmlReceived on Fri Mar 05 2010 - 18:00:29 CST