DROP TABLESPACE ESBJKDATA INCLUDING CONTENTS AND DATAFILES;
DROP TABLESPACE ESBJKINDEX INCLUDING CONTENTS AND DATAFILES;
DROP USER esbjk cascade ;
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 ;
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 ;