My Oracle Support Banner

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

Last updated on FEBRUARY 03, 2019

Applies to:

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


Upgrade of "Oracle Text" component from to 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 /
ERROR at line 1:
ORA-00903: invalid table name
ORA-06512: at line 9


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

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