Best way to import data while oracle 11g OL6 database is open and in read/write mode
I am on a OL6 11Gr2 single instance.
If I am attempting to do do a full database (or multiple schemas) import using impdp when the database is open in read/write mode
- what happens when the import attempts to import data into a table with a row lock?
Does the impdb process log the exception and continue on with the rest of the import? Does it retry a number of times?
Does the import process fail?
I am looking for the best way to import data while the database is open in read/write mode.
Thank you for your assistance.