Oracle如何创建表空间

create user frame identified by tiger;

grant create session to frame; 

grant create table to frame; 

grant create tablespace to frame; 

grant create view to frame; 

grant dba to frame;

alter user  frame default role DBA;

create tablespace framework  

datafile 'E:/oracleData/framework.dbf'  

size 500M  

autoextend on next 5M maxsize 3000M; 

alter user frame quota unlimited on framework;

grant all privileges  TO framework;

posted @ 2014-06-06 14:20  需要GIS小工具找我  阅读(1441)  评论(0编辑  收藏  举报