多項選擇題

Which two statements are true regarding the Oracle Data Pump export and import operations（）

A.You cannot export data from a remote database.
B.You can rename tables during an import operation.
C.You can overwrite existing dump files during an export operation.
D.You can compress the data during export but not the metadata because it is not supported.

題目列表

你可能感興趣的試題

單項選擇題

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
微信掃碼免費搜題