--create user tablespace
CREATE TABLESPACE ejbexample_data
LOGGING
DATAFILE '/home/oracleTableSpace/ejbexample_DATE01.DBF'
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;
--create user temp tablespace
CREATE TEMPORARY TABLESPACE ejbexample_temp
TEMPFILE '/home/oracleTableSpace/ejbexample_temp01.DBF'
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;
--create user and set default tablespace
CREATE USER ejbexample IDENTIFIED BY baosheng1994
DEFAULT TABLESPACE ejbexample_data
TEMPORARY TABLESPACE ejbexample_temp;
-- gant dba authority to user
grant dba TO ejbexample
CREATE TABLESPACE ejbexample_data
LOGGING
DATAFILE '/home/oracleTableSpace/ejbexample_DATE01.DBF'
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;
--create user temp tablespace
CREATE TEMPORARY TABLESPACE ejbexample_temp
TEMPFILE '/home/oracleTableSpace/ejbexample_temp01.DBF'
SIZE 32M
AUTOEXTEND ON
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;
--create user and set default tablespace
CREATE USER ejbexample IDENTIFIED BY baosheng1994
DEFAULT TABLESPACE ejbexample_data
TEMPORARY TABLESPACE ejbexample_temp;
-- gant dba authority to user
grant dba TO ejbexample