ORA-39127 When Exporting Failed Domain Indexes (Doc ID 2099391.1)

Last updated on OCTOBER 03, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 12.1.0.2 and later
Information in this document applies to any platform.

Symptoms


Exporting failed domain indexes threw error ORA-39127 showing the SQL text having the version unquoted.

The SQL text having the version unquoted.  For example, the version is shown as ' || version || ':

     sql_str :=
             'local_str := ' ||
             'SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_METADATA(''' ||
             index_name || ''',''' || index_schema || ''',''' || type_name ||
             ''',''' || type_schema || ''',' || version || ',newblock,' ||
             to_char(l_flags) || ')';


The 'version' needs to be wrapped with single quote "'" as:

     sql_str :=
             'local_str := ' ||
             'SYS.DBMS_EXPORT_EXTENSION.GET_DOMAIN_INDEX_METADATA(''' ||
             index_name || ''',''' || index_schema || ''',''' || type_name ||
             ''',''' || type_schema || ''',''' || version || ''',newblock,' ||
             to_char(l_flags) || ')';



Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms