Which statement is true about using the Export/Import m…

Which statement is true about using the Export/Import method for migrating data when upgrading to Oracle
Database 12c?

Which statement is true about using the Export/Import method for migrating data when upgrading to Oracle
Database 12c?

A.
It automatically restarts a Data Pump Export or Import job after a failure is connected and the job continues
from the point of failure.

B.
It can be used to migrate a database only if the source and target databases are hosted on the same
endian format.

C.
It can be used to migrate a database only if the source database does not have any tablespace in read-only
mode.

D.
It allows migration of a database directly over network links.



Leave a Reply 4

Your email address will not be published. Required fields are marked *


Richard

Richard

well, A is also correct.

Mike

Mike

I think D is the correct one.

https://docs.oracle.com/database/121/UPGRD/expimp.htm#UPGRD52674

You can use the Data Pump Import utility with a database link to perform a full database import from a source database to a destination database without intermediate dump files.

Not A:
If a Data Pump Export or Import job encounters an unrecoverable error, then the job can be restarted after the condition inducing the failure is corrected. The job continues automatically from the point of failure.

Meaning… not automatically restarts job. Job needs to be restarted manually after failure correction, but job automatically continues from the point of failure.

Richard

Richard

Sorry, I don’t think A is correct because the job would have to be manually restarted and it would continue from the point of failure.