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';

posted on 2017-11-07 20:34  杨杨yang  阅读(212)  评论(0编辑  收藏  举报