按年和按月创建表空间

------------按月创建表空间-----------

create tablespace TORN_01 logging datafile 'D:\oradate\TORN_01.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local;

create tablespace TORN_02 logging datafile 'D:\oradate\TORN_02.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local

create tablespace TORN_03 logging datafile 'D:\oradate\TORN_03.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local;

create tablespace TORN_04 logging datafile 'D:\oradate\TORN_04.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local;

create tablespace TORN_05 logging datafile 'D:\oradate\TORN_05.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local;

create tablespace TORN_06 logging datafile 'D:\oradate\TORN_06.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local;

create tablespace TORN_07 logging datafile 'D:\oradate\TORN_07.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local;

create tablespace TORN_08 logging datafile 'D:\oradate\TORN_08.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local;

create tablespace TORN_09 logging datafile 'D:\oradate\TORN_09.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local;

create tablespace TORN_10 logging datafile 'D:\oradate\TORN_10.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local;

create tablespace TORN_11 logging datafile 'D:\oradate\TORN_11.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local;

create tablespace TORN_12 logging datafile 'D:\oradate\TORN_12.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local;

------------按年创建表空间-----------

create tablespace TORN_0101 logging datafile 'D:\oradate\TORN_0101.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local;

create tablespace TORN_0102 logging datafile 'D:\oradate\TORN_0102.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local

create tablespace TORN_0103 logging datafile 'D:\oradate\TORN_0103.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local;

create tablespace TORN_0104 logging datafile 'D:\oradate\TORN_0104.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local;

create tablespace TORN_0105 logging datafile 'D:\oradate\TORN_0105.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local;

create tablespace TORN_0106 logging datafile 'D:\oradate\TORN_0106.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local;

create tablespace TORN_0107 logging datafile 'D:\oradate\TORN_0107.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local;

create tablespace TORN_0108 logging datafile 'D:\oradate\TORN_0108.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local;

create tablespace TORN_0109 logging datafile 'D:\oradate\TORN_0109.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local;

create tablespace TORN_0110 logging datafile 'D:\oradate\TORN_0110.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local;

create tablespace TORN_0111 logging datafile 'D:\oradate\TORN_0111.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local;

create tablespace TORN_0112 logging datafile 'D:\oradate\TORN_0112.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local

create tablespace TORN_0113 logging datafile 'D:\oradate\TORN_0113.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local;

create tablespace TORN_0114 logging datafile 'D:\oradate\TORN_0114.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local;

create tablespace TORN_0115 logging datafile 'D:\oradate\TORN_0115.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local;

create tablespace TORN_0116 logging datafile 'D:\oradate\TORN_0116.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local;

create tablespace TORN_0117 logging datafile 'D:\oradate\TORN_0117.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local;

create tablespace TORN_0118 logging datafile 'D:\oradate\TORN_0118.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local;

create tablespace TORN_0119 logging datafile 'D:\oradate\TORN_0119.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local;

create tablespace TORN_0120 logging datafile 'D:\oradate\TORN_0120.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local;

create tablespace TORN_0121 logging datafile 'D:\oradate\TORN_0121.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local;

create tablespace TORN_0122 logging datafile 'D:\oradate\TORN_0122.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local

create tablespace TORN_0123 logging datafile 'D:\oradate\TORN_0123.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local;

create tablespace TORN_0124 logging datafile 'D:\oradate\TORN_0124.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local;

create tablespace TORN_0125 logging datafile 'D:\oradate\TORN_0125.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local;

create tablespace TORN_0126 logging datafile 'D:\oradate\TORN_0126.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local;

create tablespace TORN_0127 logging datafile 'D:\oradate\TORN_0127.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local;

create tablespace TORN_0128 logging datafile 'D:\oradate\TORN_0128.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local;

create tablespace TORN_0129 logging datafile 'D:\oradate\TORN_0129.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local;

create tablespace TORN_0130 logging datafile 'D:\oradate\TORN_0130.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local;

create tablespace TORN_0131 logging datafile 'D:\oradate\TORN_0131.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local;

 --------------------------放弃表空间及对接得DBF文件--------

drop tablespace torn01 including contents and datafiles cascade constraint;
drop tablespace torn02 including contents and datafiles cascade constraint;
drop tablespace torn03 including contents and datafiles cascade constraint;
drop tablespace torn04 including contents and datafiles cascade constraint;
drop tablespace torn05 including contents and datafiles cascade constraint;
drop tablespace torn06 including contents and datafiles cascade constraint;
drop tablespace torn07 including contents and datafiles cascade constraint;
drop tablespace torn08 including contents and datafiles cascade constraint;
drop tablespace torn09 including contents and datafiles cascade constraint;
drop tablespace torn10 including contents and datafiles cascade constraint;
drop tablespace torn11 including contents and datafiles cascade constraint;
drop tablespace torn12 including contents and datafiles cascade constraint;
drop tablespace torn13 including contents and datafiles cascade constraint;
drop tablespace torn14 including contents and datafiles cascade constraint;
drop tablespace torn15 including contents and datafiles cascade constraint;
drop tablespace torn16 including contents and datafiles cascade constraint;
drop tablespace torn17 including contents and datafiles cascade constraint;
drop tablespace torn18 including contents and datafiles cascade constraint;
drop tablespace torn19 including contents and datafiles cascade constraint;
drop tablespace torn20 including contents and datafiles cascade constraint;
drop tablespace torn21 including contents and datafiles cascade constraint;
drop tablespace torn22 including contents and datafiles cascade constraint;
drop tablespace torn23 including contents and datafiles cascade constraint;
drop tablespace torn24 including contents and datafiles cascade constraint;
drop tablespace torn25 including contents and datafiles cascade constraint;
drop tablespace torn26 including contents and datafiles cascade constraint;
drop tablespace torn27 including contents and datafiles cascade constraint;
drop tablespace torn28 including contents and datafiles cascade constraint;
drop tablespace torn29 including contents and datafiles cascade constraint;
drop tablespace torn30 including contents and datafiles cascade constraint;
drop tablespace torn31 including contents and datafiles cascade constraint;