Database Utilities (MOSC)

MOSC Banner

Best way to import data while oracle 11g OL6 database is open and in read/write mode

edited Jul 24, 2017 12:29PM in Database Utilities (MOSC) 1 commentAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center