Oracle表空间代码

CREATE TABLESPACE TBS01
DATAFILE 'E:\app\YY\oradata\JWGL\TBS01.dbf' SIZE 10M;

CREATE TABLESPACE TBS02
DATAFILE 'E:\app\YY\oradata\JWGL\TBS02.dbf'SIZE 10M
AUTOEXTEND ON NEXT 128K
MAXSIZE 1024M
/

SELECT tablespace_name, extent_management,segment_space_management,contents,status
from dab_tablespaces;
/
 

SELECT file_name, bytes/1024/1024 AS MB, status FROM dba_data_files 
WHERE tablespace_name='TBS02';

/
ALTER TABLESPACE TBS01 RENAME TO TBSONE
/
ALTER TABLESPACE TBS02
ADD DATAFILE 'E:\app\YY\oradata\JWGL\TBS022.DBF' SIZE 5M
/
ALTER TABLESPACE TBSONE OFFLINE;
/
ALTER TABLESPACE TBSONE ONLINE;
/
CREATE BIGFILE TABLESPACE TBSBIG
DATAFILE 'E:\app\YY\oradata\YWGL\TBSBIG.dbf' SIZE 4G;
/

DROP TABLESPACE TBSBIG INCLUDING CONTENTS
/
CREATE TEMPORARY TABLESPACE temptbs
TEMPFILE 'G:\app\Administrator\oradata\orcl\temptbs02.dbf' SIZE 20M  REUSE
EXTENT MANAGEMENT LOCAL UNIFORM SIZE 10M;s
/

ALTER DATABASE DEFAULT TEMPORARY TABLESPACE temptbs02
/
select tablespace_name from dba_temp_files
/
CREATE TEMPORARY TABLESPACE temptbs03
TEMPFILE 'E:\app\YY\oradata\JWGL\temptbs03.dbf' SIZE 10M TABLESPACE GROUP temptbsgroup
/

alter tablespace temptbs02 TABLESPACE GROUP temptbsgroup
/
select * from dba_tablespace_groups
/

ALTER TABLESPACE temptbs02 TABLESPACE GROUP ''
/
CREATE UNDO TABLESPACE undotbs
DATAFILE 'E:\app\YY\oradata\JWGL\undotbs.dbf'SIZE 2M REUSE
/

--设置该空间脱机状态
ALTER TABLESPACE TBSONE OFFLINE;

--手动在操作系统中对数据文件TBS01.DBF重命名为TBS01.DBF，或者将它移动到其他位置
--更改数据文件名称和路径
ALTER TABLESPACE TBSONE RENAME DATAFILE
'E:\app\YY\oradata\jwgl\TBS01.DBF' TO 'E:\app\YY\oradata\jwgl\TBSONE.DBF';

--设置该空间联机状态
ALTER TABLESPACE TBSONE ONLINE;
/

ALTER TABLESPACE TBS02
DROP DATAFILE 'E:\app\YY\oradata\JWGL\TBS022.DBF'
/
表需要自己创建  仅供参考