*****SELECT STATEMENT*****:

SQL> select tablespace_name,status from dba_tablespaces
2 where tablespace_name = 'TBPLMSTS';

TABLESPACE_NAME STATUS
------------------------------ ---------
TBPLMSTS ONLINE

*****CREATE STATEMENT*****:

CREATE TABLE TBTEST.TBSPLMAT
(REF_TS_NO NUMBER(8) ,
ISSUER_CD VARCHAR(10) ,
NXT_DUE_DT DATE ,
PN_NO CHAR(16))
TABLESPACE TBPLMSTS
STORAGE (
INITIAL 12288
NEXT 4096
MINEXTENTS 1
MAXEXTENTS 5
PCTINCREASE 0
)
PCTFREE 10
/

*****ERROR MESSAGE in SQLPLUS*****:

SQL> @cre_tbsplmat
CREATE TABLE TBTEST.TBSPLMAT
*
ERROR at line 1:
ORA-00959: tablespace 'TBPLMSTS' does not exist