| ORA: 31633 unable to create master table :SYS.SYS_EXPORT_SCHEMA_05" [message #565576] |
Wed, 05 September 2012 06:16  |
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 #565590 is a reply to message #565589] |
Wed, 05 September 2012 07:14  |
 |
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
