My Oracle Support Banner

Error During Database Upgrade To (Doc ID 1562018.1)

Last updated on APRIL 01, 2020

Applies to:

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


In the process of upgrading our production environment from apps version r12.1.2 to r12.1.3 and the database from to
In the database upgrade following document 1276368.1 step 9, running catupgrd.sql

SQL> create table dr$waiting (
 2 wtg_cid number NOT NULL,
 3 wtg_rowid rowid,
 4 wtg_pid number default 0,
 5 primary key (wtg_cid, wtg_pid, wtg_rowid)
 6 )
 7 organization index;

Table created.

SQL> insert into dr$waiting
 2 select unique *
 3 from dr$waiting_old;
insert into dr$waiting
ERROR at line 1:
ORA-01654: unable to extend index CTXSYS.SYS_IOT_TOP_955299 by 128 in
tablespace CTXSYS

SQL> drop table dr$waiting_old;

Table dropped.

Failed while loading the data from dr$waiting_old to dr$waiting, but still dropped the dr$waiting_old table.


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.