My Oracle Support Banner

ORA-01403 From Oracle Text's Postupgrade ctxposup.sql Script (Doc ID 2475629.1)

Last updated on JULY 20, 2024

Applies to:

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

Symptoms

An ORA-01403 is generated during Oracle Text's Post-upgrade steps for 12.2 and above:

The catupgrd0.log spool file shows:

...
11:39:44 SQL> REM ========================================================================
11:39:44 SQL> REM Post-upgrade steps
11:39:44 SQL> REM ========================================================================
11:39:44 SQL>
11:39:44 SQL> @@ctxposup.sql
...
...
11:39:44 SQL>
11:39:44 SQL> REM ========================================================================
11:39:44 SQL> REM special case; default policy ENT_EXT_DICT_OBJ
11:39:44 SQL> REM ========================================================================
11:39:44 SQL>
11:39:44 SQL>
11:39:44 SQL> declare
11:39:44   2    l_owner#  number;
11:39:44   3    l_errnum  number;
11:39:44   4    l_count   number;
11:39:44   5
11:39:44   6  begin
11:39:44   7    select user# into l_owner# from sys."_BASE_USER" where name='CTXSYS';
11:39:44   8    select idx_id into l_count from dr$index where
11:39:44   9      idx_name = 'ENT_EXT_DICT_OBJ' and
11:39:44  10      idx_owner# = l_owner#;
11:39:44  11
11:39:44  12    /* if this object does not exist yet, create it. */
11:39:44  13    if (0 = l_count) then
11:39:44  14      CTX_DDL.create_policy('CTXSYS.ENT_EXT_DICT_OBJ',
11:39:44  15        filter        => 'CTXSYS.NULL_FILTER',
11:39:44  16        section_group => 'CTXSYS.NULL_SECTION_GROUP',
11:39:44  17        lexer         => 'CTXSYS.BASIC_LEXER',
11:39:44  18        stoplist      => 'CTXSYS.EMPTY_STOPLIST',
11:39:44  19        wordlist      => 'CTXSYS.BASIC_WORDLIST'
11:39:44  20    );
11:39:44  21    end if;
11:39:44  22  exception
11:39:44  23    when others then
11:39:44  24      l_errnum := SQLCODE;
11:39:44  25      if (l_errnum = -20000) then
11:39:44  26        null;
11:39:44  27      else
11:39:44  28        raise;
11:39:44  29      end if;
11:39:44  30  end;
11:39:44  31  /
declare
*
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at line 28
ORA-06512: at line 8
...

 

Changes

 

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
Changes
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.