Oracle(基础操作)

一个数据库 orcl
系统用户
sys/sys
system/system

新建表空间
ztb_new

create tablespace ztb_new datafile  'D:\app\yxd\oradata\orcl\ztb_new.dbf' size 100m  
autoextend on  next 32m maxsize 2048m 

新建用户
ztb_new/ztb

create user ztb_new identified by ztb default tablespace ztb_new

赋权限

grant connect,resource,dba to ztb_new