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