mysql创建表空间创建用户_ORACLE 创建表空间和用户

#创建表空间 CREATE SMALLFILE TABLESPACE USERNAME DATAFILE '/home/oracle/oradata/orcl/USERNAME' SIZE 500M LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO #修改表空间 alter tablespace USERNAME ADD datafile '/home/oracle/oradata

#创建表空间

CREATE SMALLFILE TABLESPACE "USERNAME" DATAFILE '/home/oracle/oradata/orcl/USERNAME'

SIZE 500M LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO

#修改表空间

alter tablespace USERNAME ADD datafile '/home/oracle/oradata/orcl/USERNAME.dbf'

size 500m autoextend on next 200m maxsize 3072m;

#删除表空间

DROP TABLESPACE USERNAME INCLUDING CONTENTS AND DATAFILES;

#删除用户

DROP USER 用户名 CASCADE;

#创建用户

create user 用户名 identified by “密码” default tablespace USERNAME temporary tablespace TEMP profile DEFAULT;

-- Grant/Revoke role privileges

grant connect to 用户名with admin option;

grant dba to 用户名with admin option;

grant resource to 用户名with admin option;

-- Grant/Revoke system privileges

grant unlimited tablespace to 用户名with admin option;

本文原创发布php中文网，转载请注明出处，感谢您的尊重！