Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Job "HR"."SYS_IMPORT_TABLE_01" completed with 1 error(s) at 03:41:25
--将要导入的数据库已经存在表，未设置特别导入参数，因此保错，做如下处理
--删除OFS2数据库的hr用户的test表
SQL> delete test ;
2 rows deleted.
SQL> commit;
Commit complete.
SQL>
SQL> select count(*) from test;
COUNT(*)
----------
0
--重新执行导入操作
[oracle@node2 test]$ impdp hr/hellojin directory=dumptest dumpfile=tab.dmp tables=test;
Import: Release 10.2.0.1.0 - Production on Wednesday, 08 December, 2010 3:41:53
Copyright (c) 2003, 2005, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
Master table "HR"."SYS_IMPORT_TABLE_01" successfully loaded/unloaded
Starting "HR"."SYS_IMPORT_TABLE_01": hr/******** directory=dumptest dumpfile=tab.dmp tables=test
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
. . imported "HR"."TEST" 5.226 KB 2 rows
Job "HR"."SYS_IMPORT_TABLE_01" successfully completed at 03:43:20
[oracle@node2 test]$
--检查
SQL> select * from test;
ID NAME
---------- ----------
2 k
3 n
SQL>