test

select tablespace_name,status from dba_tablespaces//查看分区表  和状态

select tablespace_name,file_name,bytes from dba_data_files    //插卡数据文件

drop tablespace dinya_space02 including contents and datafiles

select tablespace_name,file_name from dba_data_files where tablespace_name='sl2'

alter tablespace dinya_space02 offline  normal

create tablespace myspace datafile 'e:/myspace.dbf' size 10m autoextend on next 5m maxsize 100m

alter tablespace myspace readonly

select tablespace_name,status from dba_tablespaces