oracle创建表空间

 

oracle创建表空间 windows

 

 

select tablespace_name,file_id,block_id,bytes ,bytes/1024/1204 m,bytes/1024/1204/1024 g,blocks from dba_free_space order by bytes desc; 

 

select tablespace_name,file_id,bytes,file_name from dba_data_files; 

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

create tablespace CTBS_STAT  

datafile 'H:\oracle\datafiles\CTBS_STAT.dbf'  size 2G  

autoextend on  

next 2G  

maxsize unlimited 

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

删除表空间

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

DROP TABLESPACE CTBS_STAT INCLUDING CONTENTS AND DATAFILES CASCADE CONSTRAINTS; 

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