创建和删除表空间

最新推荐文章于 2024-07-28 21:15:38 发布

翻译最新推荐文章于 2024-07-28 21:15:38 发布 · 422 阅读

Oracle 专栏收录该内容

7 篇文章

订阅专栏

--删除表空间及用户
drop user jros_pa cascade;
drop tablespace PA_TA_TBS including contents and datafiles cascade constraints;

--创建表空间 ,初始化大小=dmp大小*2
CREATE TABLESPACE PA_TA_TBS
    LOGGING 
    DATAFILE 'D:\svn\JROS_DEV_4.1_20160301\PA_TA_TBS.DBF' SIZE 64M REUSE
    AUTOEXTEND 
    ON NEXT 8M EXTENT MANAGEMENT LOCAL SEGMENT 
    SPACE MANAGEMENT  AUTO;

--建用户
CREATE USER jros_pa
  IDENTIFIED by "1"
  DEFAULT TABLESPACE PA_TA_TBS
  TEMPORARY TABLESPACE TEMP
  PROFILE DEFAULT;
GRANT CONNECT TO jros_pa;
GRANT RESOURCE TO jros_pa;
--dba
GRANT dba TO jros_pa;