ORA-00903: Invalid Table Name During Database Upgrade to 12.1 (Doc ID 2312050.1)

Last updated on APRIL 07, 2022

Applies to:

Symptoms

Upgrade of "Oracle Text" component from 11.2.0.4 to 12.1.0.2 fails with:

Elapsed: 00:00:00.03
14:27:44 SQL>
14:27:44 SQL> declare
14:27:44 2 sql_q varchar2(100);
14:27:44 3 begin
14:27:44 4 FOR r in (select a.object_name , a.owner from all_objects a , all_tab_columns c
14:27:44 5 where a.object_name like '%$I' and a.object_name = c.table_name and
14:27:44 6 c.column_name='TOKEN_TEXT')
14:27:44 7 LOOP
14:27:44 8 sql_q:= 'alter table '||r.owner||'.'||r.object_name||' modify (TOKEN_TYPE number(10))';
14:27:44 9 execute immediate(sql_q);
14:27:44 10 END LOOP;
14:27:44 11 end;
14:27:44 12 /
declare
*
ERROR at line 1:
ORA-00903: invalid table name
ORA-06512: at line 9

Changes

Cause

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