-
Is there a command to overwrite existing tables of the same
when using IMP73 of Oracle 7.3.4?
Here is my exsiting cmd line parameters:
IMP73 user/password file=c:\temp ignore=y commit=y
thanks,
scotta
J.Scott Adams
-
ignore=y will just append data to the existing table, I don't think it's exactly what you want. You may want to truncate your tables OUTSIDE of import and then import with ignore=y.
Jeff Hunter
-
Truncate does not delete the child records. You may want to delete cascade also if you want to wipe the existing data out or you can disable the constraints.
[Edited by kris109 on 07-09-2001 at 06:14 PM]
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
|