Oracle 创建表空间

来源:互联网 发布:淘宝店如何复制到微店 编辑:程序博客网 时间:2024/05/23 15:45
create tablespace data_xxx_xxx_xxx
logging
datafile 'data_xxx_xxx_xxx.dbf'
size 32m 
autoextend on 
next 32m maxsize UNLIMITED
extent management local;


create user xxx_xxx_xxx identified by xxx_xxx_xxx
default tablespace data_xxx_xxx_xxx;

grant connect,resource to xxx_xxx_xxx; 

grant create any view to xxx_xxx_xxx;


原创粉丝点击