| export failed due to ORACLE error 20000 encountered [message #332276] |
Tue, 08 July 2008 01:31  |
kumar.joy
Messages: 69
Registered: August 2007
Location: morrisville
|
Member |
|
|
Experts,
export is failed due oracle error 2000 encountered. can any one guide me what is wrong here.
please find the log and export parameters i am using for export.
export parameters
full=y
buffer=1048576
recordlength=1048576
record=y
grants=y
indexes=y
rows=y
compress=n
constraints=y
consistent=y
direct=y
. . exporting table IDENTITY_ITEM_NAMES 0 rows exported
. . exporting table IDENTITY_ITEM_NAMES_ATTRIBUTES 0 rows exported
. about to export GRACES_SENSES's tables via Direct Path ...
. about to export GRACES_MESSAGING's tables via Direct Path ...
. about to export GRACES_SEARCH's tables via Direct Path ...
. about to export DSTEST's tables via Direct Path ...
. about to export TESTER's tables via Direct Path ...
. exporting synonyms
. exporting views
. exporting referential integrity constraints
. exporting stored procedures
. exporting operators
. exporting indextypes
. exporting bitmap, functional and extensible indexes
EXP-00008: ORACLE error 20000 encountered
ORA-20000: Oracle Text error:
DRG-10502: index "QSTEST_SENSES"."CS_NAME_I" does not exist
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 257
ORA-06512: at line 1
EXP-00078: Error exporting metadata for index CS_NAME_I. Index creation will be skipped
EXP-00008: ORACLE error 20000 encountered
ORA-20000: Oracle Text error:
DRG-10502: index "QSTEST_SENSES"."CS_KEYWORDS_I" does not exist
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 257
ORA-06512: at line 1
EXP-00078: Error exporting metadata for index CS_KEYWORDS_I. Index creation will be skipped
EXP-00008: ORACLE error 20000 encountered
ORA-20000: Oracle Text error:
DRG-10502: index "QSTEST_SENSES"."CS_LONG_DESC_I" does not exist
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 257
ORA-06512: at line 1
EXP-00078: Error exporting metadata for index CS_LONG_DESC_I. Index creation will be skipped
EXP-00008: ORACLE error 20000 encountered
ORA-20000: Oracle Text error:
DRG-10502: index "QSTEST_SENSES"."CS_DISPLAY_NAME_I" does not exist
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 257
ORA-06512: at line 1
EXP-00078: Error exporting metadata for index CS_DISPLAY_NAME_I. Index creation will be skipped
EXP-00008: ORACLE error 20000 encountered
ORA-20000: Oracle Text error:
DRG-10502: index "QSTEST_SENSES"."CS_CLASSIFICATION_I" does not exist
ORA-06512: at "SYS.DBMS_EXPORT_EXTENSION", line 257
ORA-06512: at line 1
EXP-00078: Error exporting metadata for index CS_CLASSIFICATION_I. Index creation will be skipped
. exporting posttables actions
. exporting triggers
. exporting materialized views
. exporting snapshot logs
. exporting job queues
. exporting refresh groups and children
. exporting dimensions
. exporting post-schema procedural objects and actions
. exporting user history table
. exporting default and system auditing options
. exporting statistics
Export terminated successfully with warnings.
07/08/08 06:13:49: Oracle export warning - with warnings
|
|
|
|
|
|
|
|
|
|
| Re: export failed due to ORACLE error 20000 encountered [message #334289 is a reply to message #332536] |
Wed, 16 July 2008 01:52  |
kumar.joy
Messages: 69
Registered: August 2007
Location: morrisville
|
Member |
|
|
thanks for reply.
i am able to see indexes. please find the details
QS5XDEV:SYSTEM> select owner,index_name, table_owner,table_name,index_type from dba_indexes where index_name in ('CS_NAME_I','CS_KEYWORDS_I','CS_LONG_DESC_I','CS_DISPLAY_NAME_I','CS_CLASSIFICATION_I');
OWNER INDEX_NAME TABLE_OWNER TABLE_NAME INDEX_TYPE
------------------------------ ------------------------------ ------------------------------ ------------------------------ ---------------------------
C_PKALIY_SENSES CS_NAME_I C_PKALIY_SENSES TB_CONTENT_SEARCH DOMAIN
C_PKALIY_SENSES CS_KEYWORDS_I C_PKALIY_SENSES TB_CONTENT_SEARCH DOMAIN
C_PKALIY_SENSES CS_LONG_DESC_I C_PKALIY_SENSES TB_CONTENT_SEARCH DOMAIN
C_PKALIY_SENSES CS_CLASSIFICATION_I C_PKALIY_SENSES TB_CONTENT_SEARCH DOMAIN
C_PKALIY_SENSES CS_DISPLAY_NAME_I C_PKALIY_SENSES TB_CONTENT_SEARCH DOMAIN
C_REDDYR_SENSES CS_NAME_I C_REDDYR_SENSES TB_CONTENT_SEARCH DOMAIN
C_REDDYR_SENSES CS_KEYWORDS_I C_REDDYR_SENSES TB_CONTENT_SEARCH DOMAIN
C_REDDYR_SENSES CS_LONG_DESC_I C_REDDYR_SENSES TB_CONTENT_SEARCH DOMAIN
C_REDDYR_SENSES CS_CLASSIFICATION_I C_REDDYR_SENSES TB_CONTENT_SEARCH DOMAIN
C_REDDYR_SENSES CS_DISPLAY_NAME_I C_REDDYR_SENSES TB_CONTENT_SEARCH DOMAIN
QSTEST_SENSES CS_CLASSIFICATION_I QSTEST_SENSES TB_CONTENT_SEARCH DOMAIN
QSTEST_SENSES CS_NAME_I QSTEST_SENSES TB_CONTENT_SEARCH DOMAIN
QSTEST_SENSES CS_KEYWORDS_I QSTEST_SENSES TB_CONTENT_SEARCH DOMAIN
QSTEST_SENSES CS_LONG_DESC_I QSTEST_SENSES TB_CONTENT_SEARCH DOMAIN
QSTEST_SENSES CS_DISPLAY_NAME_I QSTEST_SENSES TB_CONTENT_SEARCH DOMAIN
15 rows selected.
|
|
|
|
| Re: export failed due to ORACLE error 20000 encountered [message #334925 is a reply to message #334289] |
Fri, 18 July 2008 12:26 |
kumar.joy
Messages: 69
Registered: August 2007
Location: morrisville
|
Member |
|
|
experts,
I was did some investigation on it. I found that “database dictionary is out of sync with the Text dictionary”.
how to find the above problem. please follow below steps.
select OWNER, INDEX_NAME, TABLE_OWNER, TABLE_NAME, ITYP_NAME, DOMIDX_STATUS FROM DBA_INDEXES where index_name in ('CS_NAME_I','CS_KEYWORDS_I','CS_LONG_DESC_I','CS_DISPLAY_NAME_I','CS_CLASSIFICATION_I') and owner='owner_name';
this will provide some information. like this
OWNER INDEX_NAME TABLE_OWNER TABLE_NAME ITYP_NAME DOMIDX_STATU
------------------------------ ------------------------------ ------------------------------ ------------------------------ ------------------------------ ------------
QSTEST_SENSES CS_CLASSIFICATION_I QSTEST_SENSES TB_CONTENT_SEARCH CONTEXT VALID
QSTEST_SENSES CS_DISPLAY_NAME_I QSTEST_SENSES TB_CONTENT_SEARCH CONTEXT VALID
QSTEST_SENSES CS_KEYWORDS_I QSTEST_SENSES TB_CONTENT_SEARCH CONTEXT VALID
QSTEST_SENSES CS_LONG_DESC_I QSTEST_SENSES TB_CONTENT_SEARCH CONTEXT VALID
QSTEST_SENSES CS_NAME_I QSTEST_SENSES TB_CONTENT_SEARCH CONTEXT
--
again check with text directory
SELECT * FROM CTXSYS.CTX_INDEXES WHERE IDX_NAME IN
('CS_NAME_I','CS_KEYWORDS_I','CS_LONG_DESC_I','CS_DISPLAY_NAME_I','CS_CLASSIFICATION_I')
AND IDX_OWNER='owner_name'
now you did not receive any result.
in order to fix this problem. you have 2 options.
drop and recreate index
or drop the index if you don't need it.
in my case i got positive result. i was came out of this problem.
why i am posting this: this information might be helpful to others.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
