1、表空间创建
create tablespace test_ora_sql datafile
'G:\data\oracle_datafile\test_ora_sql001.dbf' size 512M autoextend on next 512M maxsize UNLIMITED,
'G:\data\oracle_datafile\test_ora_sql002.dbf' size 512M autoextend on next 512M maxsize UNLIMITED
BLOCKSIZE 16k
EXTENT MANAGEMENT LOCAL;
2、表空间删除
drop tablespace TEST_ORA_SQL including contents and datafiles