建表空间:
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