when create a table,then show error ora-00952 tablespace tsb_1 not exist

QUESTION:When create a table,then show error ora-00952 tablespace tsb_1 not exist.

STEP:

1.select user table tablespace.

SELECT username,DEFAULT_TABLESPACE,temporary_tablespace FROM dba_users WHERE username='LJB';

2.select user owner tablespace.

SELECT * FROM User_Tablespaces;

3.alter user default tablespace.

ALTER USER ljb DEFAULT TABLESPACE USERS;

4.checking tablespace

SELECT username,DEFAULT_TABLESPACE,temporary_tablespace FROM dba_users WHERE username='LJB';

原文地址:https://www.cnblogs.com/yjhlsbnf/p/7800947.html