-
Export/Import - Urgent!
Hi Guys,
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.
Regards,
Sudheer
-
truncate your tables and disable your constraints BEFORE you import...
Jeff Hunter
-
Hi
Hi,
How do i truncate the tables?
and how do i disable the constraints?
Pls do help
-
TRUNCATE TABLE your_table_name
and
ALTER TABLE your_table_name DISABLE CONSTRAINT your_constraint_name
Make yourself familiar with http://tahiti.oracle.com
Jeff Hunter
-
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
Brisbane Australia
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|