Hi, do i need to drop the table first, then import it in schema. Does oracle overwrites the table if not dropped.
Printable View
Hi, do i need to drop the table first, then import it in schema. Does oracle overwrites the table if not dropped.
Hi,
You don't need to drop the table before the import.
Use the option "IGNORE=Y" in the import command.
Nir
but it will try to put all the data in, so you have to sort our your data issues
You can either drop your table or truncate it. In the second case use ignore=y option as appointed by Nir.
If I import the table, the message is import terminated successfully with warnings. And when i query the table I don't get the table data(old data) present in the imported file. when I have tried with ignore=y option, it gives error as unique constraint voilated, import terminated successfully with warnings. And when i query the table, it is not updated with imported data.
Your kind help is highly appreciated.
Dear Nir, if i don't drop the table, the table is not updating with the imported data. The table is referenced by foreign keys. I tried with ignore=y options, this also not working.Quote:
Originally Posted by nir_s
You do not update a table doing an import. Import will try to insert every single row it finds in the dump file into the affected table.
Now you added a valuable piece of information... you have Referential Integrity constraints involving that table.
Are you sure you want to import "only" that table?... are you sure you are gonna get a RI consistent environment after that?
If you do, you have to deal with RI constraints; disable them... import... enable them.
Once you have your constraints disabled... what part of You can either drop your table or truncate it. In the second case use ignore=y option as appointed by Nir is not clear to you?