Character size issues when creating a tablespace

SQL> create tablespace test datafile 'y: \ test. dbf' size 20 M;

The name of the actually created tablespace is TEST.

Execute the following three commands to delete the tablespace:

SQL> drop tablespace test;

The tablespace has been deleted.

SQL> drop tablespace TEST;

The tablespace has been deleted.

SQL> drop tablespace "TEST ";

The tablespace has been deleted.

That is, if "" is not added to the provided tablespace name when the tablespace is deleted, the characters submitted to the table are converted to uppercase.

-------------------------------------------------------------------------------

If you add "" to the tablespace name when creating a tablespace, for example:

SQL> create tablespace "test" datafile 'y: \ test. dbf' size 20 M;

The created tablespace name is test. If you use drop tablespace test2009 to delete the tablespace, an error is returned:

SQL> drop tablespace test;
Drop tablespace test
*
Row 3 has an error:
ORA-00959: tablespace 'test' does not exist

You can run the following command successfully:

SQL> drop tablespace "test ";

The tablespace has been deleted.

Whether or not "" is added during table space creation, the name of the actually generated data file is in upper case.