Home » RDBMS Server » Server Utilities » export failed due to ORACLE error 20000 encountered (solaris 10 oracle 10.2.0.3)
export failed due to ORACLE error 20000 encountered [message #332276] Tue, 08 July 2008 01:31 Go to next message
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 #332529 is a reply to message #332276] Tue, 08 July 2008 17:30 Go to previous messageGo to next message
gaperumal
Messages: 8
Registered: June 2008
Location: Chennai India
Junior Member

Oracle version please


Arangaperumal
Chennai,India
Re: export failed due to ORACLE error 20000 encountered [message #332533 is a reply to message #332529] Tue, 08 July 2008 19:11 Go to previous messageGo to next message
kumar.joy
Messages: 69
Registered: August 2007
Location: morrisville
Member
oracle version is 10.2.0.3
Re: export failed due to ORACLE error 20000 encountered [message #332536 is a reply to message #332276] Tue, 08 July 2008 19:47 Go to previous messageGo to next message
BlackSwan
Messages: 25049
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & FOLLOW the Posting Guidelines as stated in URL above


Do the reported indexes actually exist?
Post proof.
Re: export failed due to ORACLE error 20000 encountered [message #334289 is a reply to message #332536] Wed, 16 July 2008 01:52 Go to previous messageGo to next message
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 Go to previous message
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.
Previous Topic: SQL loader issure with direct='Y'
Next Topic: I need to import execl to oracle - HAve a free software?
Goto Forum:
  


Current Time: Fri Dec 09 09:57:30 CST 2016

Total time taken to generate the page: 0.09880 seconds