c:\> sqlplus

Enter user-name: sys as sysdba
Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options


SQL> select name,ts# from v$tablespace;

NAME                                  TS#
------------------------------ ----------
SYSTEM                                  0
SYSAUX                                  1
UNDOTBS1                                2
USERS                                   4
TEMP                                    3
CATALOGTS                               9
CATTS                                   7

7 rows selected.

SQL> drop tablespace catalogts including contents and datafiles;

Tablespace dropped.

SQL> drop tablespace catts including contents and datafiles;

Tablespace dropped.

SQL> select name,ts# from v$tablespace;

NAME                                  TS#
------------------------------ ----------
SYSTEM                                  0
SYSAUX                                  1
UNDOTBS1                                2
USERS                                   4
TEMP                                    3

SQL> create tablespace rcatts datafile 'c:\oradata\rcat\rcatts01.dbf' size 100m
  2  autoextend on next 10m maxsize 500m;
create tablespace rcatts datafile 'c:\oradata\rcat\rcatts01.dbf' size 100m
*
ERROR at line 1:
ORA-01119: error in creating database file 'c:\oradata\rcat\rcatts01.dbf'
ORA-27038: created file already exists
OSD-04010: <create> option specified, file already exists

SQL> 

c:\> sqlplus

Enter user-name: sys as sysdba
Enter password:

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> create tablespace ts datafile 'c:\oradata\rcat\ts01.dbf' size 100m;

Tablespace created.

SQL> drop tablespace ts including contents and datafiles;

Tablespace dropped.

SQL> create tablespace tss datafile 'c:\oradata\rcat\ts01.dbf' size 100m;

Tablespace created.

SQL>