创建表空间
create tablespace mytb1 datafile '/u01/oradata/mytb01.dfb' SIZE 10M AUTOEXTEND ON NEXT 5M MAXSIZE 1024M;
create tablespace mytb1 datafile '/u01/oradata/mytb01.dfb' SIZE 10M AUTOEXTEND ON NEXT 5M MAXSIZE UNLIMITED;
create tablespace mytb1 datafile '/u01/oracle/9i/oradata/gt9i/mytb01.dbf' size 10m autoextend off,'/u01/oracle/9i/oradata/gt9i/mytb02.dbf' size 10m autoextend off;
CREATE TEMPORARY TABLESPACE mytbtmp1 TEMPFILE '/u01/oradata/mytbtmp1.dfb' SIZE 10M AUTOEXTEND ON NEXT 5M MAXSIZE 10240M;
CREATE undo TABLESPACE mytbtmp1 TEMPFILE '/u01/oradata/mytbtmp1.dfb' SIZE 10M AUTOEXTEND ON NEXT 5M MAXSIZE 10240M;
关于临时表空间
无法设置只读
无法rename
始终是nologging
不会备份
不会恢复
使表空间脱机
alter tablespace mytb1 offline;--注意有4个选项，默认normal，TEMPORARY|IMMEDIATE|FOR RECOVER
使表空间联机
alter tablespace mytb1 online;
使表空间只读
alter tablespace mytb1 read only;
使表空间读写
alter tablespace mytb1 read write;
增加数据文件
alter tablespace mytb1 add datafile '/u01/oracle/9i/oradata/gt9i/mytb01.dbf' size 10m;
调整数据文件大小
alter tablespace mytb1 datafile '/u01/oracle/9i/oradata/gt9i/mytb01.dbf' resize 10m;
移动数据文件
alter tablespace mytb1 rename datafile '/u01/oracle/9i/oradata/gt9i/mytb01.dbf' to '/u01/oracle/9i/oradata/gt9i/mytb02.dbf';
数据库层面移动数据文件
alter database rename file '/u01/oracle/9i/oradata/gt9i/mytb01.dbf' to '/u01/oracle/9i/oradata/gt9i/mytb02.dbf';
删除表空间
drop tablespace mytb1 including contents and datafiles;
DROP TABLESPACE mytb1 INCLUDING CONTENTS CASCADE CONSTRAINTS;
-The End-