oracle 创办用户及表空间

分类: IT文章 • 2022-07-18 23:00:15

oracle 创建用户及表空间

create tablespace INSWELLSPAC datafile '/home/oracle/oradata/inswell/db.dbf' size 1G AUTOEXTEND ON NEXT 500K MAXSIZE UNLIMITED;

create user INITINSWELL identified by initinswell default tablespace INSWELLSPAC;

grant connect,dba,resource to initinswell