OraFAQ Forum: Server Utilities » Dump from 9i DB to be imported to 11g directly

Home » RDBMS Server » Server Utilities » Dump from 9i DB to be imported to 11g directly (Oracle DB's -9i and 11g Sun Solaris)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Dump from 9i DB to be imported to 11g directly [message #509694]

Tue, 31 May 2011 05:35

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.

Report message to a moderator

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

Michel Cadot
Messages: 68501
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

Report message to a moderator

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

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

Report message to a moderator

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

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

Report message to a moderator

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

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

Report message to a moderator

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

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.

Report message to a moderator

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

Michel Cadot
Messages: 68501
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

Report message to a moderator

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

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

Report message to a moderator

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

Michel Cadot
Messages: 68501
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Sep 25 01:49:18 CDT 2023