I need know the best pratice to upgrade 9i to 11g database using export and import.
One would be exporting 9i from source (9i), import to destination(9i) and then upgrade to 11g -or-
export 9i from source (9i) import to destinatiion (11g).
Need document for the same.
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 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.