单项选择题
You have created a database link， devdb.us.oracle.com， between the databases PRODDB and DEVDB. You want to import schema objects of the HR user using Oracle Data Pump from thedevelopment database， DEVDB， to the production database， PRODDB. You execute the following command on the target database server：
$impdp system/manager directory = DB_DATA dumpfile = schemas.dat schemas = hr
flashback_time = 2004-02-03 09：00
The command fails， displaying the following error： ORA-39001： invalid argument value
ORA-39000： bad dump file specification
ORA-31640： unable to open dump file “/home/oracle/schema/schemas.dat” for read ORA-27037： unable to obtain file status What would you do to overcome the error（）
A.remove the dumpfile option in the command
B.remove the flashback_time option in the command
C.remove the dumpfile option and add the network_link = devdb.us.oracle.com option in the command（Replace thedumpfile option with the network_link = devdb.us.oracle.com）
D.add the user， SYSTEM， to the schemas option in the command
E.remove the schemas option and add the network_link = devdb.us.oracle.com option in the command
F.add network_link = devdb.us.oracle.com option in the command
相关考题
-
单项选择题
You want to move all objects of the APPS user in the test database to the DB_USER schema of theproduction database. Which option of IMPDP would you use to accomplish this task（）
A.FULL
B.SCHEMAS
C.TRANSFORM
D.REMAP_SCHEMA
E.REMAP_TABLESPACE -
多项选择题
InwhichsituationsdoestheOracleDataPumpuseexternaltablesandnotthedirectpathloadwhileexportingatable（）
A.if a table is not in a cluster
B.if a table has an active trigger
C.if a table has an encrypted
D.if a table has a column of data type LONG defined on it
E.if a table has a referential integrity constraint defined on it -
多项选择题
WhichtwostatementsaretrueregardingOracleDataPump（）
A.EXPDP and IMPDP are the client components of Oracle Data Pump.
B.DBMS_DATAPUMP PL/SQL packages can be used independently of the Data Pump clients.
C.Oracle Data Pump export and import operations can be performed only by users with the SYSDBA privilege.
D.Oracle Data Pump imports can be done from the export files generated in the export utility of previous versions.
E.EXPDP and IMPDP use the procedures provided by DBMS_METADATA to execute export and import commands.
