Oracle 表空间

    create tablespace helloworl001 datafile 'd:\helloworld.dbf' size 200M uniform size 128K;

alter tablespace 表空间名 offline

alter tablespace 表空间名 online

alter tablespace 表空间名 read only

alter tablespace helloworl001 read only   

alter tablespace helloworl001 read write 

select * from all_tables where tablespace_name='HELLOWORL001'

select tablespace_name, table_name from user_tables

where table_name in ('HELLOWORLD001','EMP')

drop tablespace 名称 including contents and datafiles

create tablespace hello002 datafile 'D:\helloworld002.dbf' size 20M uniform 128K

select * from helloworld

create table helloworld002(userid varchar2(20), username varchar2(20), memo varchar2(40)) tablespace hello002;

alter tablespace hello002 add datafile 'd:\helloworld003.dbf' size 50M

alter database datafile 'd:\helloworld002.dbf' resize 50M

alter database datafile 'd:\helloworld002.dbf' autoextend on next 10M maxsize 500M

select file_name, tablespace_name from dba_data_files where file_name like '%HELLO%'

alter tablespace hello002 offline;