topic Re: user constraints export / import in Operating System - HP-UX

user constraints export / import

Enrico Venturi — Thu, 23 Nov 2006 03:50:12 GMT

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

Re: user constraints export / import

Yogeeraj_1 — Thu, 23 Nov 2006 04:13:36 GMT

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

Re: user constraints export / import

Eric Antunes — Thu, 23 Nov 2006 04:13:48 GMT

Hi Enrico,

Try it with CONSTRAINTS=y

Best Regards,

Eric Antunes

Re: user constraints export / import

Peter Godron — Thu, 23 Nov 2006 04:17:57 GMT

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.

Re: user constraints export / import

avik — Thu, 23 Nov 2006 15:57:35 GMT

include the below parameter too in your export statement.

full=y