My Oracle Support Banner

DRG-50857 ORA-01430 WHILE EXECUTING DBMS_REDEFINITION.START_REDEF_TABLE (Doc ID 2716162.1)

Last updated on APRIL 17, 2023

Applies to:

Oracle Text - Version 19.3.0.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.0.1 version, Generic/Default

When attempting to

NGEN@KURT@SQL > begin
 2 dbms_redefinition.start_redef_table( 'NGEN', 'DBILD', 'DBILD_NP', NULL, dbms_redefinition.cons_use_pk, '', 'DBILD1940');
 3 dbms_redefinition.finish_redef_table( 'NGEN', 'DBILD', 'DBILD_NP', 'DBILD1940');
 4 end;
 5 /

the following error occurs.

ERROR
-----------------------
durung online redefinition we get
ERROR at line 1:
ORA-42012: error occurred while completing the redefinition
ORA-29955: error occurred in the execution of ODCIINDEXEXCHANGEPARTITION routine
ORA-20000: Oracle Text error:
DRG-50857: oracle error in drvxtab.exchange_index_tables
DRG-50857: oracle error in drvxtab.create_index_tables
ORA-01031: insufficient privileges
ORA-06512: at "CTXSYS.DRUE", line 171
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 944
ORA-06512: at line 2
ORA-20000: Oracle Text error:
DRG-50857: oracle error in drvxtab.exchange_index_tables
DRG-50857: oracle error in drvxtab.create_index_tables
ORA-01031: insufficient privileges
ORA-06512: at "CTXSYS.DRUE", line 171
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 944
ORA-06512: at line 2
ORA-20000: Oracle Text error:
DRG-50857: oracle error in drvxtab.exchange_index_tables
DRG-50857: oracle error in drvxtab.create_index_tables
ORA-01031: insufficient privileges
ORA-06512: at "CTXSYS.DRUE", line 171
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 944
ORA-06512: at line 2
ORA-20000: Oracle Text error:
DRG-50857: oracle error in drvxtab.exchange_index_tables
DRG-50857: oracle error in drvxtab.create_index_tables
ORA-01031: insufficient privileges
ORA-06512: at "CTXSYS.DRUE", line 171
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 944
ORA-06512: at line 2
ORA-20000: Oracle Text error:
DRG-50857: oracle error in drvxtab.exchange_index_tables
DRG-50857: oracle error in drvxtab.create_index_tables
ORA-01031: insufficient privileges
ORA-06512: at "CTXSYS.DRUE", line 171
ORA-06512: at "CTXSYS.TEXTINDEXMETHODS", line 944
ORA-06512: at line 2
ORA-06512: at "SYS.DBMS_REDEFINITION", line 146
ORA-06512: at "SYS.DBMS_REDEFINITION", line 3976
ORA-06512: at "SYS.DBMS_REDEFINITION", line 5232
ORA-06512: at line 3

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.