Operating System - HP-UX
1748286 Members
3247 Online
108761 Solutions
New Discussion юеВ

Re: user constraints export / import

 
SOLVED
Go to solution
Enrico Venturi
Super Advisor

user constraints export / import

Hello colleagues,
I'm exporting an ORACLE 8.1.7 database through the exp command: parameters are:
OWNER=
snml
USERID=snml/snml@rm745_1_ded
FILE=/alcatel/MigrDataRepository/ORACLE/db_export.dmp

I see that some constraints, namely user constraints of NOT NULL, are not present in the imported database...
Before the import I drop any tablespace on the target database then I run the import ... after that I see that no such constraints are present.

Why?????

Thanks for your support

Enrico
4 REPLIES 4
Yogeeraj_1
Honored Contributor
Solution

Re: user constraints export / import

Hi enrico,

The default settings for CONSTRAINTS for both exp and imp is 'Y'

Unless you have explicitly mentioned the contrary, the check constraints should be there!

can you please re-check your script.

you may also query the dictionary view user_constraints for the names and the count.

Also, verify the export and import logs.


kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Eric Antunes
Honored Contributor

Re: user constraints export / import

Hi Enrico,

Try it with CONSTRAINTS=y

Best Regards,

Eric Antunes
Each and every day is a good day to learn.
Peter Godron
Honored Contributor

Re: user constraints export / import

Enrico,
if you just use the exp command it will guide you through the process.

What sort of constraints are you referring to?

Not null constraints are on columns on tables, not users ! Users have grants and priviledges.
avik
Valued Contributor

Re: user constraints export / import

include the below parameter too in your export statement.

full=y