Error During Database Upgrade 11.2.0.1 To 11.2.0.3 (Doc ID 1562018.1)

Last updated on FEBRUARY 08, 2017

Applies to:

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

Symptoms

In the process of upgrading our production environment from apps version r12.1.2 to r12.1.3 and the database from 11.2.0.1 to 11.2.0.3.
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.

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