建表空间

DROP TABLESPACE ESBJKDATA INCLUDING CONTENTS AND DATAFILES;
DROP TABLESPACE ESBJKINDEX INCLUDING CONTENTS AND DATAFILES;
DROP USER esbjk cascade ;

create tablespace ESBJKDATA datafile '+DATADG2' size 100m autoextend on next 10M maxsize 20480M;

alter  tablespace ESBJKDATA add datafile '+DATADG2' size 100m autoextend on next 10M maxsize 20480M;

create tablespace ESBJKINDEX datafile '+DATADG2' size 100m autoextend on next 10M maxsize 20480M;
alter  tablespace ESBJKINDEX add datafile '+DATADG2' size 100m autoextend on next 10M maxsize 20480M;

CREATE USER esbjk PROFILE default IDENTIFIED BY esbjk DEFAULT TABLESPACE ESBJKDATA TEMPORARY TABLESPACE temp ACCOUNT UNLOCK;
grant connect,resource to esbjk ;
grant dba to esbjk ;