Home » RDBMS Server » Server Utilities » Dump from 9i DB to be imported to 11g directly (Oracle DB's -9i and 11g Sun Solaris)
icon8.gif  Dump from 9i DB to be imported to 11g directly [message #509694] Tue, 31 May 2011 05:35 Go to next message
sirpskct
Messages: 4
Registered: May 2011
Location: Chennai
Junior Member
Hi Friends, I tried to import a dump in 11g that was taken in oracle 9i. The import started but it hangs after some time. Exactly say it check only the character set of the DB's then it hangs. Please help and let me know if there are any specific procedures to import a dump from 9i to 11g directly.
Re: Dump from 9i DB to be imported to 11g directly [message #509699 is a reply to message #509694] Tue, 31 May 2011 05:44 Go to previous messageGo to next message
Michel Cadot
Messages: 67743
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Copy and paste the execution starting from the command line you entered.
Before, Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.

Regards
Michel
Re: Dump from 9i DB to be imported to 11g directly [message #509701 is a reply to message #509694] Tue, 31 May 2011 05:48 Go to previous messageGo to next message
jamal_s
Messages: 2
Registered: July 2009
Location: Kuwait
Junior Member
I remember it happened for me some time. May be it has something to do with environment setting. What I did was, go to oracle's home suppose D:\app\ora11g\product\11.2.0\dbhome_1\bin\imp system/system file='urdumpfile' ....

Regards

Jamal
Re: Dump from 9i DB to be imported to 11g directly [message #509705 is a reply to message #509699] Tue, 31 May 2011 05:58 Go to previous messageGo to next message
sirpskct
Messages: 4
Registered: May 2011
Location: Chennai
Junior Member
Oracle 9i DB version - 9.2.0.7.0
Oracle 11g DB version - 11.2.0.1.0
Re: Dump from 9i DB to be imported to 11g directly [message #509706 is a reply to message #509705] Tue, 31 May 2011 05:59 Go to previous messageGo to next message
sirpskct
Messages: 4
Registered: May 2011
Location: Chennai
Junior Member
Jamal, Thanks for u reply... I did this before but then also the same issue .. Smile
Re: Dump from 9i DB to be imported to 11g directly [message #509708 is a reply to message #509706] Tue, 31 May 2011 06:07 Go to previous messageGo to next message
ThomasG
Messages: 3211
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
Conclusion on the available information: Something is wrong. What is a mystery, since you don't show us what you actually do.
Re: Dump from 9i DB to be imported to 11g directly [message #509718 is a reply to message #509706] Tue, 31 May 2011 07:19 Go to previous messageGo to next message
Michel Cadot
Messages: 67743
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Tue, 31 May 2011 12:44
Copy and paste the execution starting from the command line you entered.
Before, Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.
Also always post your Oracle version, with 4 decimals.

Regards
Michel

Re: Dump from 9i DB to be imported to 11g directly [message #515681 is a reply to message #509694] Tue, 12 July 2011 21:02 Go to previous messageGo to next message
rsager
Messages: 17
Registered: June 2011
Location: Sydney, Australia
Junior Member
hi sirpskct
Your issue might be associated with the NLS_LANG settings defined in both the source and target DB's being different (use SQLPLUS as sys to execute SQL> select * from NLS_DATABASE_PARAMETERS; )
Once you have established what the NLS are...in the export set that environment variable (plus the $ORACLE_HOME, $ORACLE_SID) prior to the exp.

Then set the NLS_LANG and other DB variables before execting the imp.

Also, the imp would have produced some sort of log...what was in that?

Cheers
Roger
Re: Dump from 9i DB to be imported to 11g directly [message #515738 is a reply to message #515681] Wed, 13 July 2011 02:46 Go to previous message
Michel Cadot
Messages: 67743
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can say nothing about what OP did and have to do with what have been posted (that is almost nothing).

Regards
Michel
Previous Topic: import to different tablespace
Next Topic: SQL*Loader-704: Internal error: ulconnect: OCIServerAttach [0]
Goto Forum:
  


Current Time: Sat Feb 27 01:46:46 CST 2021