oracle tablespace name 转换为大写

1、查看表空间名字为小写。

SQL> create tablespace “sun” datafile ‘+data’ size 1m;

Tablespace created.

SQL> select tablespace_name from dba_tablespaces;

TABLESPACE_NAME

SYSTEM
SYSAUX
UNDOTBS1
TEMP
USERS
UNDOTBS2
SUN
T1
sun

2、创建表使用小写名表空间报错

SQL> create table test1(id int) tablespace sun;
create table test1(id int) tablespace sun
*
ERROR at line 1:
ORA-00959: tablespace ‘SUN’ does not exist

SQL> create table test1(id int) tablespace SUN;
create table test1(id int) tablespace SUN
*
ERROR at line 1:
ORA-00959: tablespace ‘SUN’ does not exist

oracle 默认为大写

3、正确用法

SQL> create table test1(id int) tablespace “sun”;

Table created.

4、转换为大写

SQL> alter tablespace “sun” rename to SUN;

Tablespace altered.

5、查看

SQL> select tablespace_name from dba_tablespaces;

TABLESPACE_NAME

SYSTEM
SYSAUX
UNDOTBS1
TEMP
USERS
UNDOTBS2
T1
SUN