Oracle数据库初始化配置语句

2017-01-03 19:12:58来源:CSDN作者:xcg340123人点击

第七城市

1.创建数据表空间

CREATE TABLESPACE "MSGC" DATAFILE   '/u02/oradata/msgc.dbf' SIZE 21474836480  AUTOEXTEND ON NEXT 104857600 MAXSIZE 32767M  LOGGING ONLINE PERMANENT BLOCKSIZE 8192  EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO;

2.创建临时表空间

--暂时未用到create temporary tablespace temp tempfile '/u02/oradata/temp.dbf' size 50m autoextend on next 50m maxsize 20480m extent management local; 

3.创建用户

create user citymsgc identified by "msgc78_+sj" default tablespace msgctemporary tablespace temp; 

4.用户授权

--基本权限即可(没有设置dba)--grant connect,resource to username; -- Grant/Revoke role privileges grant connect to city_fy with admin option;grant resource to city_fy with admin option;-- Grant/Revoke system privileges grant debug any procedure to city_fy with admin option;grant debug connect session to city_fy with admin option;grant unlimited tablespace to city_fy with admin option;
第七城市

最新文章

123

最新摄影

微信扫一扫

第七城市微信公众平台