Home » RDBMS Server » Server Utilities » impde include (10.2.0.4)
impde include [message #552607] Thu, 26 April 2012 20:28
lerry
Messages: 16
Registered: December 2011
Junior Member
hi:
i expdp as:
expdp system/oracle full=y directory=dumpdir dumpfile=full.dmp logfile=full.log

then i impdp as:
impdp system/oracle directory=dumpdir dumpfile=full.dmp tables=smp.CELL_SORT_INFO_BY_CUSTOMER query=smp.CELL_SORT_INFO_BY_CUSTOMER:\"where org_id=51 and create_time\<to_date\(\'2010-10-01\',\'yyyy-mm-dd\'\)\" remap_tablespace=app_tb:dell_tb logfile=impdp_table.log


impdp success,but not index impdp
then i add include=index
the results is no data impdp.how to impdp all of the tables information;
Previous Topic: ORA-39002,ORA-39070,ORA-29283,ORA-06512
Next Topic: ORA-01950: no privileges on tablespace
Goto Forum:
  


Current Time: Sat Aug 08 04:54:26 CDT 2020