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
Printable View
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
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.
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]