oracle笔记一：建库建表

1. 创建表空间

create tablespace datatest datafile '/data/app/oracle/oradata/data_test.dbf' size 2048M;  

2. 创建用户

create user test identified by test default tablespace datatest;     --新建user用户

3. 授权

grant dba to test;        --授予dba权限

grant connect,resource to test;            --授予connect,resource权限给test