16:07:10 SQL> select TABLESPACE_NAME,STATUS from dba_tablespaces;
TABLESPACE_NAME STATUS
----------------------- ---------
SYSTEM ONLINE
UNDOTBS1 ONLINE
SYSAUX ONLINE
TEMP ONLINE
USERS ONLINE
xtcur ONLINE
xthis ONLINE
xtview ONLINE
ITMTBS ONLINE
XTOCR ONLINE
10 rows selected.
16:07:27 SQL> alter tablespace xthis add datafile '/oradata/hsbank/xthis2' size 5120M;
alter tablespace xthis add datafile '/oradata/hsbank/xthis2' size 5120M
*
ERROR at line 1:
ORA-00959: tablespace 'XTHIS' does not exist
16:07:56 SQL>
16:09:53 SQL> alter tablespace "xthis" add datafile '/oradata/hsbank/xthis2' size 5120M;
TABLESPACE_NAME STATUS
----------------------- ---------
SYSTEM ONLINE
UNDOTBS1 ONLINE
SYSAUX ONLINE
TEMP ONLINE
USERS ONLINE
xtcur ONLINE
xthis ONLINE
xtview ONLINE
ITMTBS ONLINE
XTOCR ONLINE
10 rows selected.
16:07:27 SQL> alter tablespace xthis add datafile '/oradata/hsbank/xthis2' size 5120M;
alter tablespace xthis add datafile '/oradata/hsbank/xthis2' size 5120M
*
ERROR at line 1:
ORA-00959: tablespace 'XTHIS' does not exist
16:07:56 SQL>
16:09:53 SQL> alter tablespace "xthis" add datafile '/oradata/hsbank/xthis2' size 5120M;
Tablespace altered.
加双引号.