Home » RDBMS Server » Server Utilities » Datapump: importing check constraints (Oracle DB SE 11g)
Datapump: importing check constraints [message #538051] Tue, 03 January 2012 13:12 Go to next message
Sven256
Messages: 3
Registered: January 2012
Junior Member
Hi,

I am trying to use the datapump tool to migrate a 10g db to 11g. Everything works fine except for the "nameless" check constraints.

Am I doing something wrong or is there a fair explanation for it?

Thanks
Re: Datapump: importing check constraints [message #538055 is a reply to message #538051] Tue, 03 January 2012 13:21 Go to previous messageGo to next message
Littlefoot
Messages: 19892
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:
Everything works fine except for the "nameless" check constraints.

How do they "work"? Any error? If so, which one?
Re: Datapump: importing check constraints [message #538057 is a reply to message #538055] Tue, 03 January 2012 13:25 Go to previous messageGo to next message
Sven256
Messages: 3
Registered: January 2012
Junior Member
Nope, no errors related to the constraints, they are not created. Other (named) constraints are created properly.

The export I use is a full export of the 10g db, no exclude parameters or other special options.
Re: Datapump: importing check constraints [message #538058 is a reply to message #538051] Tue, 03 January 2012 13:25 Go to previous messageGo to next message
Michel Cadot
Messages: 60012
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Read your post; do you see anything that shows us what is your error?

Copy and paste what you did and got.

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: Datapump: importing check constraints [message #538059 is a reply to message #538058] Tue, 03 January 2012 13:28 Go to previous messageGo to next message
BlackSwan
Messages: 23158
Registered: January 2009
Senior Member
I don't know what you have.
I don't know what you do.
I don't know what you see.
It is really, Really, REALLY difficult to fix a problem that can not be seen.
use COPY & PASTE so we can see what you do & how Oracle responds.
Re: Datapump: importing check constraints [message #538063 is a reply to message #538059] Tue, 03 January 2012 13:39 Go to previous messageGo to next message
Sven256
Messages: 3
Registered: January 2012
Junior Member
As said:

I do a full export on the 10g database (RAC): expdp with no other special parameters except for the necessary files (output, log).
After that I do a normal import in a newly created 11g database (RAC): impdp with again no special parameters except for the necessary files (input, log).

The log file of the export contains no errors except for compilation errors on the packages because of missing grants to sys objects. But no errors reported about constraints, tables or other objects.

When I check the imported objects (through the view all_objects) I count 4000 constraints less then on the source db, all 4000 are nameless check constraints.
Re: Datapump: importing check constraints [message #538065 is a reply to message #538063] Tue, 03 January 2012 13:47 Go to previous messageGo to next message
BlackSwan
Messages: 23158
Registered: January 2009
Senior Member
Please understand the following statement is true.
Different Oracle versions contain different objects.

You have a few alternatives available to you.
1) Ignore this observation & concentrate on actual problems & errors.
2) File a bug report with MOS
3) run in circles & scream & shout that the Sky is Falling.
Re: Datapump: importing check constraints [message #538068 is a reply to message #538063] Tue, 03 January 2012 14:00 Go to previous message
Michel Cadot
Messages: 60012
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Michel Cadot wrote on Tue, 03 January 2012 20:25
Read your post; do you see anything that shows us what is your error?

Copy and paste what you did and got.

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


You can ignore what we said.
We can ignore what you ask.
It is YOUR problem and we can live with it.

Regards
Michel
Previous Topic: Export XML
Next Topic: Import dump file without 2 tables
Goto Forum:
  


Current Time: Sun Dec 21 16:24:09 CST 2014

Total time taken to generate the page: 0.18940 seconds