hello when i import using this exclude clause why constraint is imported
my task is here
i import hr.employees and hr.department and hr.location table
now when i import this using this syntax into lg user
E:\oracle\product\10.2.0\db_1\BIN>impdp lg/lg@prac remap_schema=hr:lg dumpfile=h
r2.dmp directory=practice exclude=constraint,ref_constraint,index table_exists_a
ction=replace logfile=lgsc.log tables=employees,departments
now when i check this employess and department table contraing using this
SQL> SELECT CONSTRAINT_NAME,CONSTRAINT_TYPE,TABLE_NAME FROM USER_CONSTRAINTS;
CONSTRAINT_NAME C TABLE_NAME
------------------------------ - ------------------------------
EMP_JOB_NN C EMPLOYEES
EMP_HIRE_DATE_NN C EMPLOYEES
EMP_EMAIL_NN C EMPLOYEES
EMP_LAST_NAME_NN C EMPLOYEES
DEPT_NAME_NN C DEPARTMENTS
SYS_C0028420 C SALES
SYS_C0028419 C SALES
SYS_C0028417 C SUPPLIER
SYS_C0028416 C SUPPLIER
SYS_C0028393 C EMP_TABLE
SUPPLIER_PK P SUPPLIER
CONSTRAINT_NAME C TABLE_NAME
------------------------------ - ------------------------------
PK_SOTRE P SALES
so why this constraint not exclude i use this exclude clause into this my import syntax
[Updated on: Wed, 15 February 2012 05:09]
Report message to a moderator
] 
Blog
Search
Help
Members
Register
Login
Home
