| Export of indexes fails [message #428915] |
Fri, 30 October 2009 14:10  |
munira13
Messages: 14
Registered: March 2007
|
Junior Member |
|
|
I am trying to perform an export of only indexes using the pump utility. Following is the export statement:
expdp.exe dbo/pwd@v3qa1 directory=exp_imp_dir include=INDEX logfile=indexes_exp.log dumpfile=indexes.dmp
I am getting the following error:
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 0 KB
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/INDEX/FUNCTIONAL_AND_BITMAP/INDEX
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTICS/FUNCTIONAL_AND_BITMAP/INDEX_STATISTICS
Processing object type SCHEMA_EXPORT/TABLE/INDEX/DOMAIN_INDEX/INDEX
ORA-31694: master table "DBO"."SYS_EXPORT_SCHEMA_07" failed to load/unload
ORA-02354: error in exporting/importing data
ORA-06550: line , column :
Job "DBO"."SYS_EXPORT_SCHEMA_07" stopped due to fatal error at 14:06:33
Thank you in advance for your help.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
