关于expdp和impdp导出导入的问题
在oracle10g中,
我用命令expdp myuser/mypwd@mydb directory=DIR dumpfile=a.dmp logfile=a.log tables=TABLEA
导出了表TABLEA,得到a.dmp文件.
在用命令G:\>impdp JEFF/jeffpwd@JEFF directory=DM_PMML_DIR dumpfile=a.dmp logfile=a.log tables=TABLEA
进行导入时,得到提示:
Import: Release 10.1.0.2.0 - Production on 星期四, 16 7月, 2009 16:13
Copyright (c) 2003, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Produc
tion
With the Partitioning, OLAP and Data Mining options
ORA-31655: no data or metadata objects selected for job
ORA-39039: Schema expression "IN ('JEFF')" contains no valid schemas.
Master table "JEFF"."SYS_IMPORT_TABLE_01" successfully loaded/unloaded
Starting "JEFF"."SYS_IMPORT_TABLE_01": JEFF/********@JEFF directory=DM_PMML_DIR
dumpfile=sox.dmp logfile=sox.log tables=TABLEA
Job "JEFF"."SYS_IMPORT_TABLE_01" successfully completed at 16:13
经查阅资料,说是需要使用REMAP_SCHEMA选项,于是加上 REMAP_SCHEMA=myuser:JEFF,但问题依然,请教各位?