oracle新建用户和表空间

/* 创建用户 */
CREATE USER "XXX"  PROFILE "DEFAULT"
    IDENTIFIED BY "XXX" DEFAULT TABLESPACE "XXX"
    ACCOUNT UNLOCK;
GRANT UNLIMITED TABLESPACE TO "XXX" WITH ADMIN OPTION;
GRANT "CONNECT" TO "XXX" WITH ADMIN OPTION;
GRANT "DBA" TO "XXX" WITH ADMIN OPTION;
GRANT "RESOURCE" TO "XXX" WITH ADMIN OPTION;
GRANT CREATE ANY SEQUENCE TO "XXX";

commit;

 

/* 创建表空间 */
CREATE TABLESPACE "XXX"
    LOGGING
    DATAFILE 'D:\XXX\XXX.ora' SIZE 50M
    EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT  AUTO;

/* 创建历史表空间 */
CREATE TABLESPACE "HIS_XXX"
    LOGGING
    DATAFILE 'D:\XXX\HIS_XXX.ora' SIZE 150M
    EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT  AUTO;  

commit;