This content has been marked as final. Show 6 replies
Which version of 11g ? You can import directly into 11g after exporting from 9i.
11gR1 Upgrade Doc - http://download.oracle.com/docs/cd/B28359_01/server.111/b28300/toc.htm
11gR2 Upgrade Doc - http://download.oracle.com/docs/cd/E11882_01/server.112/e10819/toc.htm
I have already read those docs. I would like to know if some one has already implemented this.
I need steps to be followed. so on.
I am sure this has been done before. The steps are in the docs I referenced above. (e.g. http://download.oracle.com/docs/cd/B28359_01/server.111/b28300/expimp.htm#i262317)
At a high level, these would be the steps -
1. Install 11g software in a separate OH and patch up as needed.
2. Export from source database.
3. Create "empty" database and tablespaces on 11g target.
4. Import into 11g database.
Try to import your users only. Don't run IGNORE=Y and FULL=Y. Then Use scripts to recreate your security model.
Why export/import? Why not upgrade using oracle upgrade?
What do you mean by empty database?