TTS Import Fails With ORA-01647 When the Index Status is UNUSABLE
(Doc ID 2773404.1)
Last updated on APRIL 17, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 11.2.0.4 and laterInformation 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 "<<<
>>>>" ("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 "<<<
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