ORA-00903: Invalid Table Name During Database Upgrade to 12.1

(Doc ID 2312050.1)

Last updated on OCTOBER 04, 2017

Applies to:

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

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

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