/*====================================================*/
临时表空间
CREATE TEMPORARY TABLESPACE xx_temp
TEMPFILE 'path...'
SIZE xxM
AUTOEXTEND ON | OFF
NEXT xxM
MAXSIZE xxM
EXTENT MANAGEMENT LOCAL;
表空间
CREATE TABLESPACE xx
LOGGING
DATAFILE 'path...'
SIZE xxM
AUTOEXTEND ON | OFF
NEXT xxM
MAXSIZE xxM
EXTENT MANAGEMENT LOCAL;
删除表空间:
DROP TABLESPACE tbspace_name;
DROP TABLESPACE tbspace_name INCLUDING CONENTS AND DATAFILES;
修改表空间:
/* 表空间 重命名 */
ALTER TABLESPACE tb_space_name RENAME TO new_name;
/* 修改表空间大小 */
ALTER TABLESPACE tb_space_name DATAFILE '' RESIZE xxM;
/* 添加数据文件 */
ALTER TABLESPACE tb_space_name ADD DATAFILE '' SIZE xxM;
/* 归档模式下脱机 */
ALTER TABLESPACE tb_space_name OFFLINE IMMEDIATE;
/* 联机 */
ALTER TABLESPACE tb_space_name ONLINE;
/*====================================================*/
创建用户_分配_表空间
CREATE USER user_name IDENTIFIED BY pwd
DEFAULT TABLESPACE tb_space_name
TEMPORARY TABLESPACE temp_tb_space;
/*====================================================*/
临时表空间
CREATE TEMPORARY TABLESPACE xx_temp
TEMPFILE 'path...'
SIZE xxM
AUTOEXTEND ON | OFF
NEXT xxM
MAXSIZE xxM
EXTENT MANAGEMENT LOCAL;
表空间
CREATE TABLESPACE xx
LOGGING
DATAFILE 'path...'
SIZE xxM
AUTOEXTEND ON | OFF
NEXT xxM
MAXSIZE xxM
EXTENT MANAGEMENT LOCAL;
删除表空间:
DROP TABLESPACE tbspace_name;
DROP TABLESPACE tbspace_name INCLUDING CONENTS AND DATAFILES;
修改表空间:
/* 表空间 重命名 */
ALTER TABLESPACE tb_space_name RENAME TO new_name;
/* 修改表空间大小 */
ALTER TABLESPACE tb_space_name DATAFILE '' RESIZE xxM;
/* 添加数据文件 */
ALTER TABLESPACE tb_space_name ADD DATAFILE '' SIZE xxM;
/* 归档模式下脱机 */
ALTER TABLESPACE tb_space_name OFFLINE IMMEDIATE;
/* 联机 */
ALTER TABLESPACE tb_space_name ONLINE;
/*====================================================*/
创建用户_分配_表空间
CREATE USER user_name IDENTIFIED BY pwd
DEFAULT TABLESPACE tb_space_name
TEMPORARY TABLESPACE temp_tb_space;
/*====================================================*/