ORACLE手动建库建用户脚本

基本但很重要。
SQL> create tablespace birt datafile '/home/oracle/birt.dbf' size 200M autoextend on next 10M;

Tablespace created.

SQL> create temporary tablespace birt_tmp tempfile '/home/oracle/birt_tmp.dbf' size 50M;

Tablespace created.

SQL>  create user birt identified by birt default tablespace birt temporary tablespace birt_tmp;

User created.

SQL> grant connect,resource,dba to birt;

Grant succeeded.

SQL>