Create_schemas

CREATE TABLESPACE EPM_DAT DATAFILE ‘EPM_DAT.DBF’ SIZE 1024M AUTOEXTEND ON;

CREATE USER PLN_ENERSA IDENTIFIED BY ora1604BGH DEFAULT TABLESPACE EPM_DAT QUOTA unlimited ON EPM_DAT TEMPORARY TABLESPACE TEMP;

Grant Create Session To PLN_ENERSA; Grant Create View To PLN_ENERSA; Grant Create Type To PLN_ENERSA; Grant Create Table To PLN_ENERSA; Grant Create Cluster To PLN_ENERSA; Grant Create Trigger To PLN_ENERSA; Grant Create Sequence To PLN_ENERSA; Grant Create Indextype To PLN_ENERSA; Grant Create Procedure To PLN_ENERSA; Grant Create Any Synonym To PLN_ENERSA; Grant Drop Any Synonym To PLN_ENERSA; Grant Unlimited Tablespace To PLN_ENERSA;

GRANT IMP_FULL_DATABASE TO PLN_ENERSA;

GRANT EXP_FULL_DATABASE TO PLN_ENERSA ;

DROP USER EPM11 CASCADE;

exp PLN_HYP_SNO/ora1604BGH@ORADEV compress=Y grants=Y indexes=Y rows=Y triggers=Y constraints=Y file=C:\Biwares\PLN_HYP_SNO_Mar.dmp log=C:\Biwares\PLN_HYP_SNO_Mar.log

imp PLN_HYP_SNO/ora1604BGH@ORADEV file=C:\PLN_HYP_SNO_120315.dmp log=C:\PLN_HYP_SNO_120315.log FULL=Y