sql impdp username/password DIRECTORY=dir_name DUMPFILE=dumpfile.dmp TABLES=schema.tablename 确保Data Pump 客户端和数据库服务器版本兼容: 如果不兼容,请更新 Data Pump 客户端到与数据库服务器版本一致的版本,或使用与服务器版本兼容的客户端。 检查导出内容: 如果导出操作只包含了数据而没有表定义,请重新...
Oracle Database - Enterprise Edition - Version 11.2.0.1 and later: ORA-39034 Reported By DataPump Import (IMPDP) Caused By Expdp With CONTENT=DATA_ONLY
SQL> !impdp system/oracle directory=test_dir dumpfile=exp_hist_active_sess_history.dmp tables=EXP_HIST_ACTIVE_SESS_HISTORY Import: Release 12.1.0.2.0 - Production on Tue Nov 7 02:42:10 2017 Copyright (c) 1982, 2014, Oracle and/or its affiliates. All rights reserved. Connected to: Oracl...
Oracle Agile PLM Framework - Version 9.3.5.0 and laterInformation in this document applies to any platform.GoalImported Agile database dmp file exported from another instance using agile9impdp utility.Can see below error in agile9impdp log:ORA-39034: Table TABLE_DATA:"AGILE"."ERROR_REPORT13JUL...