Home » RDBMS Server » Server Utilities » Using VERSION keyword while export. (oracle 12c - Windows server 2012)
Using VERSION keyword while export. [message #626808] Mon, 03 November 2014 05:24 Go to next message
muktha_22
Messages: 527
Registered: December 2009
Senior Member
Hi All,


Need your help.

Having a Production db of 12c version, and a UAT of 10g version.

I am using the keyword version=10g in export script, while taking export from 12c production database.
But it is not exporting all the objects, especially tables.

Any idea why?

Regards
Muktha
Re: Using VERSION keyword while export. [message #626811 is a reply to message #626808] Mon, 03 November 2014 05:42 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Because you use something that does not exist in the target version.

Re: Using VERSION keyword while export. [message #626825 is a reply to message #626811] Mon, 03 November 2014 21:47 Go to previous messageGo to next message
muktha_22
Messages: 527
Registered: December 2009
Senior Member
Hi Michel,

Thanks for the reply,

If I export without the version parameter, it includes all the tables. There is no changes in the export script format, except the VERSION keyword.


Thanks and Regards
Muktha
Re: Using VERSION keyword while export. [message #626828 is a reply to message #626825] Tue, 04 November 2014 00:06 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Expected behavior.

Re: Using VERSION keyword while export. [message #626850 is a reply to message #626828] Tue, 04 November 2014 02:34 Go to previous messageGo to next message
gazzag
Messages: 1118
Registered: November 2010
Location: Bedwas, UK
Senior Member
Quote:

But it is not exporting all the objects, especially tables.


I think OP doesn't understand why some tables appear not to be exported.
Re: Using VERSION keyword while export. [message #626853 is a reply to message #626850] Tue, 04 November 2014 02:45 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

What can I say more than "Because you use something that does not exist in the target version"?
If OP wants more then he has to post more, we cannot see what is wrong from void.

Previous Topic: Impdp - Index creation
Next Topic: IMPDP error ORA-39168
Goto Forum:
  


Current Time: Thu Mar 28 13:56:55 CDT 2024