Home » RDBMS Server » Server Utilities » exclude clause related (oracle 10g,windows server 2003 64 bit)
exclude clause related [message #543562] Wed, 15 February 2012 04:53 Go to next message
x-oracle
Messages: 380
Registered: April 2011
Location: gujarat
Senior Member
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

Re: exclude clause related [message #543563 is a reply to message #543562] Wed, 15 February 2012 05:07 Go to previous message
John Watson
Messages: 8919
Registered: January 2010
Location: Global Village
Senior Member
Shaan, you still haven't read the manual, have you? The explanation of EXCLUDE is clear. Read!
Previous Topic: Time taken in export and import
Next Topic: Improve expdp performance
Goto Forum:
  


Current Time: Tue Mar 19 05:38:40 CDT 2024