Home » RDBMS Server » Server Utilities » impde include (
impde include [message #552607] Thu, 26 April 2012 20:28
Messages: 16
Registered: December 2011
Junior Member
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: Tue Mar 02 12:15:51 CST 2021