My Oracle Support Banner

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

Last updated on APRIL 01, 2020

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

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
Symptoms
Cause
Solution


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