My Oracle Support Banner

TTS Import Fails With ORA-01647 When the Index Status is UNUSABLE (Doc ID 2773404.1)

Last updated on MAY 04, 2021

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.4 and later
Information in this document applies to any platform.

Symptoms

NOTE: In the images and/or the document content below, the user information and data used represents fictitious data from the Oracle sample schema(s)
or Public Documentation delivered with an Oracle database product. Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.

While running TTS import on target, the error:

ORA-01647: Tablespace 'tablespac_name' Is Read-only, Cannot Allocate Space In It

 

Is raised while creating an Index OR constraint that uses an index.

Example:

CREATE BITMAP INDEX "<<<index name>>>" ON "T1" ("Col1") PCTFREE 10 INITRANS 2 MAXTRANS 255 NOLOGGING STORAGE( BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
TABLESPACE "<<<tablespace name>>>" LOCAL (PARTITION "P1" PCTFREE 10 INITRANS 2 MAXTRANS 255 NOLOGGING STORAGE( INI
ORA-39083: Object type INDEX failed to create with error:
ORA-01647: tablespace '<<<tablespace name>>>' is read-only, cannot allocate space in it.

ALTER TABLE "T1" ADD CONSTRAINT "<<<name>>>" PRIMARY KEY ("ID") USING INDEX (CREATE UNIQUE INDEX "<<<>&parent=EXTERNAL_SEARCH" rel="nofollow" ON "<<<<<

>>>>" ("ID") PCTFREE 10 INITRANS 2 MAXTRANS 167
STORAGE( INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645 PCTINCREASE 0 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT) TABLESPACE "<<<>>>>" ) ENABLE
ORA-39083: Object type CONSTRAINT:"<<<<<name>>>>>" failed to create with error:
ORA-01647: tablespace '<<<tablespace name>>>' is read-only, cannot allocate space in it.

 

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.