OraFAQ Forum: Server Utilities » DMP from 11G to 10G

Home » RDBMS Server » Server Utilities » DMP from 11G to 10G (Oracle DB, 11G, Windows7 )

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

DMP from 11G to 10G [message #510834]

Wed, 08 June 2011 00:49

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?

Report message to a moderator

Re: DMP from 11G to 10G [message #510840 is a reply to message #510834]

Wed, 08 June 2011 01:07

babuknb
Messages: 1734
Registered: December 2005
Location: NJ

Senior Member

Ok then export by using 10g expdp utility

Babu

Report message to a moderator

Re: DMP from 11G to 10G [message #510848 is a reply to message #510834]

Wed, 08 June 2011 01:56

Michel Cadot
Messages: 68455
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

The generic rule is: "use the lowest version number".

Regards
Michel

Report message to a moderator

Re: DMP from 11G to 10G [message #510956 is a reply to message #510834]

Wed, 08 June 2011 11:18

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:

/forum/fa/9082/0/

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 1578 times)

Report message to a moderator

Re: DMP from 11G to 10G [message #510957 is a reply to message #510956]

Wed, 08 June 2011 11:24

cookiemonster
Messages: 13904
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?

Report message to a moderator

Re: DMP from 11G to 10G [message #510963 is a reply to message #510957]

Wed, 08 June 2011 11:40

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?

Report message to a moderator

Re: DMP from 11G to 10G [message #510964 is a reply to message #510957]

Wed, 08 June 2011 11:44

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

Report message to a moderator

Re: DMP from 11G to 10G [message #510966 is a reply to message #510963]

Wed, 08 June 2011 11:45

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jun 08 22:40:25 CDT 2023