ORACLE_SID=orcl
ORACLE_HOME=/home/oracle/app/oracle/product/11.2.0/dbhome_1
export ORACLE_SID ORACLE_HOME
export PATH=$ORACLE_HOME/bin:$PATH
sqlplus / as sysdba


drop user "BP10" CASCADE;


CREATE BIGFILE TABLESPACE BP1 ONLINE PERMANENT EXTENT MANAGEMENT LOCAL AUTOALLOCATE SEGMENT SPACE MANAGEMENT AUTO datafile '/oracle/db/oradata/BP1_01.dbf' SIZE 200G AUTOEXTEND ON NEXT 1G;


-- USER SQL
CREATE USER BP1 IDENTIFIED BY BP1
DEFAULT TABLESPACE "BP1"
TEMPORARY TABLESPACE "TEMP";

-- QUOTAS
ALTER USER BP1 QUOTA UNLIMITED ON BP1;

-- ROLES
GRANT "CONNECT" TO BP1 ;
GRANT "RESOURCE" TO BP1 ;

-- SYSTEM PRIVILEGES

-- USER SQL
ALTER USER "BP1"
DEFAULT TABLESPACE "BP1"
TEMPORARY TABLESPACE "TEMP"
ACCOUNT UNLOCK ;

-- QUOTAS
ALTER USER "BP1" QUOTA UNLIMITED ON BP1;

-- ROLES
ALTER USER "BP1" DEFAULT ROLE "CONNECT","RESOURCE";

-- SYSTEM PRIVILEGES