052-102
You want to import schema objects of the HR user using Oracle Data Pump from the development database, DEVDB, to the production database, PRODDB. A database link devdb.us.oracle.com is created between PRODDB and DEVDB.
You execute the following command on the PRODDB database server:
$ impdp system/manager directory = DB_DATA
dumpfile = schemas.dat
schemas = hr
flashback_time = "TO_TIMESTAMP('25-08-2007 14:35:00', 'DD-MM-YYYY HH24:MI:SS')"
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.Add the user, SYSTEM, to the schemas option.
B.Add the network_link = devdb.us.oracle.com option.
C.Change the dumpfile option to schema.dat@devdb.us.oracle.com.
D.Replace the schemas option with the network_link = devdb.us.oracle.com option.
E.Replace the dumpfile option with the network_link = devdb.us.oracle.com option.
通过 database link 导数据需要提供参数 network_link ,这时不会生成 dump file,所以不需要 dumpfile 参数。
【推荐】还在用 ECharts 开发大屏?试试这款永久免费的开源 BI 工具!
【推荐】国内首个AI IDE,深度理解中文开发场景,立即下载体验Trae
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步