Home » RDBMS Server » Server Utilities » Export of indexes fails (11.1.0.7)
Export of indexes fails [message #428915] Fri, 30 October 2009 14:10 Go to next message
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.

Re: Export of indexes fails [message #429206 is a reply to message #428915] Mon, 02 November 2009 09:32 Go to previous messageGo to next message
munira13
Messages: 14
Registered: March 2007
Junior Member
I was able to resolve the issue. After the oracle patch was applied the database was not patched. Running catcpu.sql helped resolve the issue.
Re: Export of indexes fails [message #429346 is a reply to message #429206] Tue, 03 November 2009 05:21 Go to previous message
ramoradba
Messages: 2454
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Thanks for your update

Sriram.
Previous Topic: ORA-24372: invalid object for describe
Next Topic: Data Pump API error help
Goto Forum:
  


Current Time: Sun Sep 25 04:24:55 CDT 2016

Total time taken to generate the page: 0.05709 seconds