oracle新建用户和表空间

转载于 2008-12-11 17:52:00 发布 · 52 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/lzming/archive/2008/12/11/1353150.html

文章标签：

#数据库

本文介绍了如何在Oracle数据库中创建新的用户账号，并为该用户分配默认表空间及额外的历史表空间。文中通过SQL语句详细展示了创建过程，包括设置用户的权限、解锁账户等操作。

/* 创建用户 */
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;

转载于:https://www.cnblogs.com/lzming/archive/2008/12/11/1353150.html