[Oracle] 建库语句

建表空间： 

CREATE SMALLFILE
    TABLESPACE "JBPM"
    LOGGING
    DATAFILE 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\JBPM.ora'
    SIZE 5M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT 
    AUTO;

 

建用户：

CREATE USER "JBPMUSER"  PROFILE "DEFAULT"
    IDENTIFIED BY "JBPMUSER" DEFAULT TABLESPACE "JBPM"
    ACCOUNT UNLOCK;
GRANT "CONNECT" TO "JBPMUSER";
GRANT "DBA" TO "JBPMUSER";
GRANT "RESOURCE" TO "JBPMUSER";

设置数据文件为自动扩展512M：

ALTER DATABASE
    DATAFILE 'D:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\JBPM.ORA'
    AUTOEXTEND
    ON NEXT  512M