I want to clear my doubt.I have a particular user for which I am transfering data from some non oracle existing dtabase and testing it.and taking export backup if it is sucessful and if not I am droping all tables and then importing data from my old backup.In droping tables it is taking too much time(2000 tables, I could not want drop user).Then I am importing table.
I want to know is tere any way to import data (previos dump) without droping tables.
Please suggest me.
Originally posted by patel_dil Yes you can import data into existing tables. Set IGNORE=Y in imp command.
If table has any rows and PK / UK CONSTRAINS
IGNORE=Y will work more slower than IGNORE=N
because oracle have to check each importing row aginst PK/UK constraint.
then if in import file we have any constraint violation oracle
have to log this row to imprt protocol (extrimly slow operation).
In my mind this isn't good recomendation.
may be truncate all tables before import can help, but i
didn't test that method newer.
yea have to agree ...process is slower with the existing data with constraints. And like shestakov suggested, maybe you can try importing the data after truncating the tables involved. But again it all depends on how critical the existing data is. Hope all this steps are done in test environment first.