Export/Import - Urgent!
I am exporting a dump file which was created using 7.3 to 9i database.
9i already contains the table structure,index and constraints and my idea is to
export only the data.
Parameter used for export are
"ROWS=y GRANTS=n INDEXES=n COMPRESS=n CONSTRAINTS=n OWNER=acc"
and parameter used for Import are
ROWS=y GRANTS=n INDEXES=y IGNORE=y FROMUSER=acc TOUSER=acc COMMIT=y"
While importing it shows some unique constraints error.
Could any one verify my parameter details ang give me some proper guidence.
truncate your tables and disable your constraints BEFORE you import...
How do i truncate the tables?
and how do i disable the constraints?
Pls do help
TRUNCATE TABLE your_table_name
ALTER TABLE your_table_name DISABLE CONSTRAINT your_constraint_name
Make yourself familiar with http://tahiti.oracle.com
Jeff, for your reply to sudheer_nm's last two questions, you showed great restraint...you must've been in a very good mood.
OCP 8i, 9i DBA
Click Here to Expand Forum to Full Width