Oracle Utilities Customer Care and Billing ORA-00959: tablespace 'CISTS_01' does not exist (Doc ID 1376162.1)

Last updated on NOVEMBER 10, 2011

Applies to:

Oracle Utilities Customer Care and Billing - Version: 2.3.1 and later   [Release: 2.3 and later ]
Information in this document applies to any platform.

Goal

While importing demo data to a consolidated database with multiple schemas (userids/schema owner ids/tablespace names are different from default), we encountered ORA-00959: tablespace 'CISTS_01' does not exist.


IMP-00017: following statement failed with ORACLE error 959:
"CREATE TABLE "C1_ISS_CTR" ("ISS_CTR_CD" CHAR(12) NOT NULL ENABLE, "BUS_OBJ_"
"CD" CHAR(30) NOT NULL ENABLE, "BO_STATUS_CD" CHAR(12) NOT NULL ENABLE, "STA"
"TUS_UPD_DTTM" DATE NOT NULL ENABLE, "ISS_CTR_DATA_AREA" CLOB, "VERSION" NUM"
"BER(5, 0) NOT NULL ENABLE) PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 S"
"TORAGE(INITIAL 262144 NEXT 262144 MINEXTENTS 1 FREELISTS 1 FREELIST GROUPS "
"1 BUFFER_POOL DEFAULT) TABLESPACE "CISTS_01" LOGGING NOCOMPRESS LOB ("ISS_C"
"TR_DATA_AREA") STORE AS BASICFILE (TABLESPACE "CISTS_01" ENABLE STORAGE IN"
" ROW CHUNK 8192 RETENTION NOCACHE LOGGING STORAGE(INITIAL 262144 NEXT 262"
"144 MINEXTENTS 1 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT))"
IMP-00003: ORACLE error 959 encountered
ORA-00959: tablespace 'CISTS_01' does not exist

Solution

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