expdp sunnyworkspace/sunnyworkspace@orcl directory=REMAP_DATAPUMP version = 11.1.0.6.0 dumpfile=dev.dmp tables=sunnyworkspace.dev reuse_dumpfiles=y CONTENT=DATA_ONLY

impdp sunnyworkspace/sunny
workspace@orcl directory=REMAP_DATAPUMP version = 11.1.0.6.0 dumpfile=dev.dmp tables = sunnyworkspace.dev remap_table=sunnyworkspace.dev:het

SQL> show user;
USER is "SUNNYWORKSPACE"
SQL> create table dev as select rownum num from dual connect by rownum <= 800;

Table created.

SQL> select count(*) from dev;

  COUNT(*)
----------
       800

SQL> create table het as select * from dev where 1=2;

Table created.

SQL> select count(*) from het;

  COUNT(*)
----------
         0

SQL> select count(*) from het;

  COUNT(*)
----------
         0

SQL> select count(*) from dev;

  COUNT(*)
----------
      1600

C:\LapTop_Users\SUNNY_PROJECT_WORK\DataBase\Dump_File>impdp sunnyworkspace/sunny
workspace@orcl directory=REMAP_DATAPUMP version = 11.1.0.6.0 dumpfile=dev.dmp re
map_table=sunnyworkspace.dev:het

Import: Release 11.1.0.6.0 - Production on Thursday, 22 March, 2012 16:50:18

Copyright (c) 2003, 2007, Oracle.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Produc
tion
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Master table "SUNNYWORKSPACE"."SYS_IMPORT_FULL_01" successfully loaded/unloaded
Starting "SUNNYWORKSPACE"."SYS_IMPORT_FULL_01":  sunnyworkspace/********@orcl di
rectory=REMAP_DATAPUMP version = 11.1.0.6.0 dumpfile=dev.dmp remap_table=sunnywo
rkspace.dev:het
Processing object type TABLE_EXPORT/TABLE/TABLE
ORA-39151: Table "SUNNYWORKSPACE"."DEV" exists. All dependent metadata and data
will be skipped due to table_exists_action of skip
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Job "SUNNYWORKSPACE"."SYS_IMPORT_FULL_01" completed with 1 error(s) at 16:50:20

create view het as select * from dev;