-> I m using oracle 8i and now I want to upgrade it to 11g. Is there any complications. I mean can i simply export a dump file from oracle 8i and import it in oracle 11g using imp tool, importing everything. If not what are not imported and what are other complications and consequences.Like any other full export/import, almost everything will be imported but not everything :http://download.oracle.com/docs/cd/B28359_01/server.111/b28319/exp_imp.htm#i1023130
saugat chatterjee wrote:Pl create a new thread for your question, instead of hijacking an old thread.
i have to upgrade the databse from 8.1.4 to 11.2
i have imported an export file from 8.1.7 to 11.2 it goes fine without errors but i know that there are still something left that dint gets upgraded soWere any errors recorded in the export or import logs ? What do you mean by "i know that there are still something left that dint gets upgraded" - how did you determine that ?
now please guide me what are the things that i have to change or set to upgrade the 8.1.7 to 11.2 completelyFollow the steps in the Upgrade Guide - http://www.oracle.com/pls/db112/to_toc?pathname=server.112/e17222/toc.htm