OraFAQ Forum: Server Utilities » Datapump: importing check constraints

Home » RDBMS Server » Server Utilities » Datapump: importing check constraints (Oracle DB SE 11g)

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

Datapump: importing check constraints [message #538051]

Tue, 03 January 2012 13:12

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

Report message to a moderator

Re: Datapump: importing check constraints [message #538055 is a reply to message #538051]

Tue, 03 January 2012 13:21

Littlefoot
Messages: 16993
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?

Report message to a moderator

Re: Datapump: importing check constraints [message #538057 is a reply to message #538055]

Tue, 03 January 2012 13:25

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.

Report message to a moderator

Re: Datapump: importing check constraints [message #538058 is a reply to message #538051]

Tue, 03 January 2012 13:25

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

Report message to a moderator

Re: Datapump: importing check constraints [message #538059 is a reply to message #538058]

Tue, 03 January 2012 13:28

BlackSwan
Messages: 20107
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.

Report message to a moderator

Re: Datapump: importing check constraints [message #538063 is a reply to message #538059]

Tue, 03 January 2012 13:39

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.

Report message to a moderator

Re: Datapump: importing check constraints [message #538065 is a reply to message #538063]

Tue, 03 January 2012 13:47

BlackSwan
Messages: 20107
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.

Report message to a moderator

Re: Datapump: importing check constraints [message #538068 is a reply to message #538063]

Tue, 03 January 2012 14:00

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

Report message to a moderator

Previous Topic:	Export XML
Next Topic:	Import dump file without 2 tables

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 23 16:12:18 CDT 2013

Total time taken to generate the page: 0.74898 seconds