Which option of Data Pump Import would you use to accomplish this?

The application tables owned by the user TEST in a test database need to be exported to the APPS schema in the production database by using Data Pump.
Which option of Data Pump Import would you use to accomplish this?

The application tables owned by the user TEST in a test database need to be exported to the APPS schema in the production database by using Data Pump.
Which option of Data Pump Import would you use to accomplish this?

A.
owner

B.
touser

C.
attach

D.
fromuser

E.
remap_schema

Explanation:
The REMAP_SCHEMA parameter changes the ownership of database objects. If you do not specify REMAP_SCHEMA, all database objects (such as tables and indexes) are created in the same user schema as in the source database, and those users must already exist in the target database. If they do not exist, then the import utility returns an error.

REF: Oracle(r) 10g Administrator Guide , 8-36



Leave a Reply 1

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


networkmanagers

networkmanagers

Correct answer is