| 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;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
