If the table already exists.
Http://www.itpub.net/thread-345521-1-1.html
--------------------------------------------------
I just want to import a table in the backup file
During the operation, all data in the table array is accidentally deleted. How to import the data in the original backup data into the array...
Write the Import Statement directly.
IMP user/pwd tables = table_name
The import failed because your table structure still exists.
The table structure exists. No? // I only deleted the data... I didn't delete the table... now I only want to export data...
I deleted the table and imported it again...
Only delete data. Only import data...
I don't know how to get it .....
Try imp ignore = y ...........
Ignore = y
Re: Try imp ignore = y ...........
Quote:
Initially released by Stephen
Ignore = y
This is a positive solution.
Check whether the original data conflicts with the data for Imp.
Let's take a look at the IMP help = y parameter.
If a table exists, you can only import data.