Home » RDBMS Server » Server Utilities » ORA: 31633 unable to create master table :SYS.SYS_EXPORT_SCHEMA_05" (oracle 11.1.0.6.0 Linux)
ORA: 31633 unable to create master table :SYS.SYS_EXPORT_SCHEMA_05" [message #565576] Wed, 05 September 2012 06:16 Go to next message
nehhaverma
Messages: 34
Registered: September 2009
Location: JAIPUR
Member
Hi

I am exporting a user using expdp utility but below error shows:

ORA-31626: job does not exist
ORA-31633: unable to create master table "SYS.SYS_EXPORT_SCHEMA_05"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT", line 978
ORA-08102: index key not found, obj# 39, file 1, block 165947 (2)


then I queried for this object:

SQL> select object_type,object_name
2 from dba_objects
3 where object_id=39;

OBJECT_TYPE OBJECT_NAME
-------------------
INDEX I_OBJ4

And try to rebuild the index

SQL> alter index I_OBJ4 rebuild;
alter index I_OBJ4 rebuild
*
ERROR at line 1:
ORA-00604: error occurred at recursive SQL level 1
ORA-00060: deadlock detected while waiting for resource

Then try to drop this

SQL> drop index I_OBJ4;
drop index I_OBJ4
*
ERROR at line 1:
ORA-00701: object necessary for warmstarting database cannot be altered

Please suggest what should I need to do to take export.
Regards//
Neha
Re: ORA: 31633 unable to create master table :SYS.SYS_EXPORT_SCHEMA_05" [message #565584 is a reply to message #565576] Wed, 05 September 2012 06:47 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
First you MUST NEVER alter/drop/create any SYS object. (Some can, you no.)
Then use dbv to check the file #1

Regards
Michel
Re: ORA: 31633 unable to create master table :SYS.SYS_EXPORT_SCHEMA_05" [message #565589 is a reply to message #565584] Wed, 05 September 2012 07:11 Go to previous messageGo to next message
nehhaverma
Messages: 34
Registered: September 2009
Location: JAIPUR
Member

how to use dbv for file#1
Re: ORA: 31633 unable to create master table :SYS.SYS_EXPORT_SCHEMA_05" [message #565590 is a reply to message #565589] Wed, 05 September 2012 07:14 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
C:\>dbv help=y

DBVERIFY: Release 10.2.0.4.0 - Production on Mer. Sept. 5 14:13:32 2012

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

Keyword     Description                    (Default)
----------------------------------------------------
FILE        File to Verify                 (NONE)
START       Start Block                    (First Block of File)
END         End Block                      (Last Block of File)
BLOCKSIZE   Logical Block Size             (8192)
LOGFILE     Output Log                     (NONE)
FEEDBACK    Display Progress               (0)
PARFILE     Parameter File                 (NONE)
USERID      Username/Password              (NONE)
SEGMENT_ID  Segment ID (tsn.relfile.block) (NONE)
HIGH_SCN    Highest Block SCN To Verify    (NONE)
            (scn_wrap.scn_base OR scn)

Regards
Michel
Previous Topic: Export only Procedures as *.proc file
Next Topic: Bad records into a Table using sql*loader
Goto Forum:
  


Current Time: Thu Mar 28 17:22:33 CDT 2024