OraFAQ Forum: Server Utilities » EXPDP Error - ORA-39127,ORA-00942,ORA-06512

Home » RDBMS Server » Server Utilities » EXPDP Error - ORA-39127,ORA-00942,ORA-06512 (Database - Oracle 11.2.0.1.0, OS - Windows Server 2008 R2 Enterprise)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

EXPDP Error - ORA-39127,ORA-00942,ORA-06512 [message #607870]

Wed, 12 February 2014 23:03

hitesh.bhatt
Messages: 84
Registered: February 2014
Location: INDIA

Member

Database: Oracle database 11.2.0.1.0
OS: Windows Server 2008 R2 Enterprise

EXPDP shows following error::

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
ORA-39127: unexpected error from call to local_str := SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_METADATA
ORA-00942: table or view does not exist
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 270
ORA-06512: at line 1
ORA-06512: at "SYS.DBMS_METADATA", line 6300
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Please help resolve the error
Thanks in advance

Report message to a moderator

Re: EXPDP Error - ORA-39127,ORA-00942,ORA-06512 [message #607873 is a reply to message #607870]

Wed, 12 February 2014 23:18

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

You either did something wrong or hit a bug; but since we don't know what you did we can't begin to guess what exactly might be wrong.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Re: EXPDP Error - ORA-39127,ORA-00942,ORA-06512 [message #607874 is a reply to message #607873]

Wed, 12 February 2014 23:22

hitesh.bhatt
Messages: 84
Registered: February 2014
Location: INDIA

Member

Thanks for your quick reply.
This database restored last month from another database.

The source database also same version / same OS but no error found in that database, whereas in this database facing this error while EXPDP.

Report message to a moderator

Re: EXPDP Error - ORA-39127,ORA-00942,ORA-06512 [message #607876 is a reply to message #607874]

Wed, 12 February 2014 23:29

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

when inputs are really 100% SAME, then results are SAME.
when results are different, then something is different.
You are free to believe what you want to believe.

Report message to a moderator

Re: EXPDP Error - ORA-39127,ORA-00942,ORA-06512 [message #607884 is a reply to message #607876]

Thu, 13 February 2014 02:00

hitesh.bhatt
Messages: 84
Registered: February 2014
Location: INDIA

Member

I found for the domain indexes in user_indexes -- domidx_opstatus=FAILED for all indexes, this might be the reason for the error while EXPDP.

Could you please let me know how to resolve this error? rebuild indexes will work?

Report message to a moderator

Re: EXPDP Error - ORA-39127,ORA-00942,ORA-06512 [message #607885 is a reply to message #607884]

Thu, 13 February 2014 02:06

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

It will not hurt, so try it.

Report message to a moderator

Re: EXPDP Error - ORA-39127,ORA-00942,ORA-06512 [message #607886 is a reply to message #607885]

Thu, 13 February 2014 02:09

hitesh.bhatt
Messages: 84
Registered: February 2014
Location: INDIA

Member

Could you please help me with any other solution to make -- domidx_opstatus=VALID ?
Thanks in advance.

Report message to a moderator

Re: EXPDP Error - ORA-39127,ORA-00942,ORA-06512 [message #607896 is a reply to message #607886]

Thu, 13 February 2014 04:58

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Why don't you want to do what you suggested?

Report message to a moderator

Re: EXPDP Error - ORA-39127,ORA-00942,ORA-06512 [message #607904 is a reply to message #607896]

Thu, 13 February 2014 05:45

hitesh.bhatt
Messages: 84
Registered: February 2014
Location: INDIA

Member

As users using this system, so they may get affected by rebuilding the index at this time.

Report message to a moderator

Re: EXPDP Error - ORA-39127,ORA-00942,ORA-06512 [message #607909 is a reply to message #607904]

Thu, 13 February 2014 07:18

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I'm afraid there is no other solution for the moment.
You can open a SR to Oracle to ask them but I bet there will say the same thing.

Note that if your index is not valid, no one is using it so you can drop it and reexecute your export.

Report message to a moderator

Re: EXPDP Error - ORA-39127,ORA-00942,ORA-06512 [message #607962 is a reply to message #607909]

Thu, 13 February 2014 22:57

hitesh.bhatt
Messages: 84
Registered: February 2014
Location: INDIA

Member

Please find the current index status for reference -

INDEX_NAME STATUS DOMIDX_OPSTATUS
IDX_XXXXX VALID FAILED

Report message to a moderator

Re: EXPDP Error - ORA-39127,ORA-00942,ORA-06512 [message #607964 is a reply to message #607962]

Thu, 13 February 2014 23:39

hitesh.bhatt
Messages: 84
Registered: February 2014
Location: INDIA

Member

I tried to rebuild the index, shows following error -

Error report -
SQL Error: ORA-29858: error occurred in the execution...
ORA-20100: MDL-0215: Unable to select string value, SQL=....
MDL-0062: Unable to initialize local environment
ORA-06512...
ORA-06512...

Report message to a moderator

Re: EXPDP Error - ORA-39127,ORA-00942,ORA-06512 [message #607971 is a reply to message #607964]

Fri, 14 February 2014 00:29

Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Drop it.

Report message to a moderator

Previous Topic:	text data to excel file
Next Topic:	SQl Loader

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Feb 06 22:11:31 CST 2025