Overwritting existing tables using IMP

[scotta]

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

[marist89]

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.

[kris109]

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]