plsql创建和删除表空间

Oracle10g 在PLSQL Developer上建立表空间脚本

创建表空间
create tablespace MOF_TEMP
datafile 'D:\oracle\product\10.2.0\oradata\orcl\MOF_TEMP.def' size 500M
autoextend on next 100M maxsize unlimited logging
extent management local autoallocate
segment space management auto;

1) DATAFILE: 表空间数据文件存放路径
2) SIZE: 起初设置为200M
3) UNIFORM: 指定区尺寸为128k,如不指定，区尺寸默认为64k
4) 空间名称MOF_TEMP与 数据文件名称 MOF_TEMP.dbf 不要求相同,可随意命名.
5) AUTOEXTEND ON/OFF 表示启动/停止自动扩展表空间
6) alter database datafile ' D:\oracle\product\10.2.0\oradata\orcl\MOF_TEMP.dbf ' resize 500m; //手动修改数据文件大小为500M

删除表空间


DROP TABLESPACE MOF_TEMP INCLUDING CONTENTS AND DATAFILES;

评论

2 楼 unimme 2016-06-08  

CREATE TABLESPACE  DhccEduBureauPlat
LOGGING
DATAFILE 'D:\edu\db_bak\DhccEduBureauPlat_DATA.DBF'
SIZE 50M
AUTOEXTEND ON
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;

CREATE USER DhccEduBureauPlat IDENTIFIED BY DhccEduBureauPlat
DEFAULT TABLESPACE DhccEduBureauPlat;




grant connect to DhccEduBureauPlat with admin option;
grant dba to DhccEduBureauPlat with admin option;
grant resource to DhccEduBureauPlat with admin option;

1 楼 unimme 2012-09-10  

-- Create the user
create user QQLEQU
  default tablespace QQLEQU
  temporary tablespace TEMP
  profile DEFAULT;
-- Grant/Revoke role privileges
grant connect to QQLEQU with admin option;
grant dba to QQLEQU with admin option;
grant resource to QQLEQU with admin option;
-- Grant/Revoke system privileges
grant unlimited tablespace to QQLEQU with admin option;