Home » RDBMS Server » Server Utilities » DMP from 11G to 10G (Oracle DB, 11G, Windows7 )
DMP from 11G to 10G [message #510834] Wed, 08 June 2011 00:49 Go to next message
itralarcon
Messages: 36
Registered: February 2011
Location: San Salvador
Member

I have lot of problem using 11G and i dont want to continue trying to repair them all. I just want to do a full DMP Export from 11G DB and Import into 10G.

The reason? No problems when using 10G before.

I try using the oracle export tool on the 11G DB, but when i try to import into 10G there's a header problem. I guess that, like in other oracle DB version, the 11G DMP isnt compatible whit the 10G import tool.

Any ideas?
Re: DMP from 11G to 10G [message #510840 is a reply to message #510834] Wed, 08 June 2011 01:07 Go to previous messageGo to next message
babuknb
Messages: 1703
Registered: December 2005
Location: NJ
Senior Member

Ok then export by using 10g expdp utility

Babu
Re: DMP from 11G to 10G [message #510848 is a reply to message #510834] Wed, 08 June 2011 01:56 Go to previous messageGo to next message
Michel Cadot
Messages: 57600
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
The generic rule is: "use the lowest version number".

Regards
Michel
Re: DMP from 11G to 10G [message #510956 is a reply to message #510834] Wed, 08 June 2011 11:18 Go to previous messageGo to next message
itralarcon
Messages: 36
Registered: February 2011
Location: San Salvador
Member

Done... Using export tool 10G... imposible to generate a full db dmp...

This is the error:

./fa/9082/0/


Sad when i try whit separated schemas there is another error and cant complete the export...

Here is the error:
http://img135.imageshack.us/img135/2974/oraerror2.jpg


Any ideas?

  • Attachment: ORA-error.jpg
    (Size: 54.35KB, Downloaded 789 times)
Re: DMP from 11G to 10G [message #510957 is a reply to message #510956] Wed, 08 June 2011 11:24 Go to previous messageGo to next message
cookiemonster
Messages: 10570
Registered: September 2008
Location: Rainy Manchester
Senior Member
Yes. Copy and paste the contents of those command windows here as plain text, in [code] tags, so we can actually read what it says.
You're not using a GUI, why on earth would you post images?
Re: DMP from 11G to 10G [message #510963 is a reply to message #510957] Wed, 08 June 2011 11:40 Go to previous messageGo to next message
itralarcon
Messages: 36
Registered: February 2011
Location: San Salvador
Member

Ok when i Try whit full= yes option:

EXP-00008.
ORA-01406.
EXP-00000.

I dont put the explanation because its in spanish..

This is when i try whit one schema:
EXP-00056.
ORA-01455.
EXP-00000.

Any suggestions?
Re: DMP from 11G to 10G [message #510964 is a reply to message #510957] Wed, 08 June 2011 11:44 Go to previous messageGo to next message
Michel Cadot
Messages: 57600
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
In addition, set your language to english or american before posting.

The problem surely comes from a different character set.
Post
- database character set for both database
- NLS_LANG value used during export and import.

And once again, post in TEXT mode NO images.

Before, Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.

Regards
Michel
Re: DMP from 11G to 10G [message #510966 is a reply to message #510963] Wed, 08 June 2011 11:45 Go to previous message
Michel Cadot
Messages: 57600
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
itralarcon wrote on Wed, 08 June 2011 18:40
Ok when i Try whit full= yes option:

EXP-00008.
ORA-01406.
EXP-00000.

I dont put the explanation because its in spanish..

This is when i try whit one schema:
EXP-00056.
ORA-01455.
EXP-00000.

Any suggestions?


Do you think we know by heart all Oracle error messages?
Post complete messages... in english.

Regards
Michel

Previous Topic: move objects from one database to another
Next Topic: load jpg picture into oracle database
Goto Forum:
  


Current Time: Wed Apr 16 09:11:05 CDT 2014

Total time taken to generate the page: 0.14048 seconds