ORA-00959: tablespace ” does not exist

Cause:

A table was created in a tablespace which doesn’t exist anymore

kIsH@x3z6zx9<^>!oerr ora 959
00959, 00000, “tablespace ‘%s’ does not exist”
// *Cause:
// *Action:

kIsH@x3z6zx9<^>create index objid on test8(object_id);
create index objid on test8(object_id)
                      *
ERROR at line 1:
ORA-00959: tablespace 'SHRINKTBS' does not exist

Action:

Set the default tablespace to another existing tablespace

sqlplus / as sysdba
kIsH@x3z6zx9<^>alter user test default tablespace users;

User altered.

Create index

kIsH@x3z6zx9<^>create index objid on test8(object_id);

Index created.

Leave a Reply