select tablespace_name,file_id,block_id,bytes,blocks from dba_free_space;
select tablespace_name,file_id,bytes,file_name from dba_data_files;
创建表空间Test_Space, 数据文件保存在test_space.dbf中,初始大小100M,自增大小50M,最大20G。
create tablespace TEST_SPACE
datafile 'D:\oracle\product\10.2.0\oradata\CIT\test_space.dbf' size 100M
autoextend on
next 50M
maxsize 20480M ;
删除表空间Test_Space,同时删除内容和数据文件。
drop tablespace foxtest including contents and datafiles;