Oracle数据库操作基础2

Oracle 表空间的操作

创建表空间

CREATE TABLESPACE caoyanjiang

    DATAFILE '/u2/oradata/topprd/caoyanjiang-01.dbf'

    SIZE 1M;

! ls /u2/oradata/topprd/caoyanjiang*

为表空间增加文件

ALTER TABLESPACE caoyanjiang ADD

DATAFILE '/u2/oradata/topprd/caoyanjiang-02.dbf' SIZE 1M;

! ls /u2/oradata/topprd/caoyanjiang*

删除表空间

DROP TABLESPACE caoyanjiang

    INCLUDING CONTENTS AND DATAFILES;

! ls /u2/oradata/topprd/caoyanjiang*

创建临时表空间

CREATE TEMPORARY TABLESPACE caoyanjiang_temp

    TEMPFILE '/u2/oradata/topprd/caoyanjiang_temp.dbf'

    SIZE 10M AUTOEXTEND ON NEXT 10M;

! ls /u2/oradata/topprd/caoyanjiang_temp*

CREATE TEMPORARY TABLESPACE caoyanjiang_temp2

    TEMPFILE '/u2/oradata/topprd/caoyanjiang_temp2.dbf'

    SIZE 10M AUTOEXTEND ON NEXT 10M;

! ls /u2/oradata/topprd/caoyanjiang_temp*

更改缺省临时表空间

ALTER DATABASE

DEFAULT TEMPORARY TABLESPACE caoyanjiang_temp2;

删除表空间

DROP TABLESPACE caoyanjiang_temp

INCLUDING CONTENTS AND DATAFILES;

! ls /u2/oradata/topprd/caoyanjiang_temp*

更改缺省临时表空间

ALTER DATABASE

    DEFAULT TEMPORARY TABLESPACE temp;

删除表空间

DROP TABLESPACE caoyanjiang_temp2

INCLUDING CONTENT