tablespace

最新推荐文章于 2025-06-15 14:01:30 发布

原创最新推荐文章于 2025-06-15 14:01:30 发布 · 190 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#user #table

/* Please modify the user sys's password and the sid name */
conn sys/sys@emcc as sysdba;

drop tablespace TBS_DIS_DAT INCLUDING CONTENTS AND DATAFILES;
drop tablespace TBS_DIS_HIS INCLUDING CONTENTS AND DATAFILES;
drop tablespace TBS_DIS_IDX INCLUDING CONTENTS AND DATAFILES;
drop tablespace TBS_DIS_TMP INCLUDING CONTENTS AND DATAFILES;

/* Create table space */
CREATE TABLESPACE TBS_DIS_DAT
   DATAFILE 'D:/eccdata/oracledb/test/dis_01' SIZE 50M,
   'D:/eccdata/oracledb/test/dis_02' SIZE 50M REUSE;

CREATE TABLESPACE TBS_DIS_HIS
   DATAFILE 'D:/eccdata/oracledb/test/dis_03' SIZE 20M,
   'D:/eccdata/oracledb/test/dis_04' SIZE 20M REUSE;

CREATE TABLESPACE TBS_DIS_IDX
   DATAFILE 'D:/eccdata/oracledb/test/dis_05' SIZE 20M,
   'D:/eccdata/oracledb/test/dis_06' SIZE 20M REUSE;

CREATE TEMPORARY TABLESPACE TBS_DIS_TMP
   TEMPFILE 'D:/eccdata/oracledb/test/dis_tmp01' SIZE 10M,
   'D:/eccdata/oracledb/test/dis_tmp02' SIZE 10M REUSE;

/* create role */
DROP ROLE DISADMIN CASCADE;
CREATE ROLE "DISADMIN" NOT IDENTIFIED;
GRANT "CONNECT" TO "DISADMIN";
GRANT "DBA" TO "DISADMIN";
GRANT "RESOURCE" TO "DISADMIN";

/* create user */
DROP USER BME CASCADE;
CREATE USER "BME"
    PROFILE "DEFAULT"
    IDENTIFIED BY "bme"
    DEFAULT TABLESPACE "TBS_DIS_DAT"
    TEMPORARY TABLESPACE "TBS_DIS_TMP" ACCOUNT UNLOCK;
GRANT DISADMIN TO BME;
GRANT UNLIMITED TABLESPACE TO BME;

COMMIT;