您的位置: 首页 > IT文章 > Oracle如何创建表空间

Oracle如何创建表空间

分类: IT文章 • 2025-01-18 16:25:19

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;