spool g:\oralog\oracreate.log

connect / as sysdba
startup pfile=&2\dbs\p_create_ecperf.ora nomount

create database ecperf
controlfile reuse
datafile '&1\oradata\ecperf\sys_ecperf' size 500M reuse
logfile '&3\oradata\ecperf\log1_ecperf' size 5000M reuse, '&3\oradata\ecperf\log2_ecperf' size 5000M reuse, '&3\oradata\ecperf\log3_ecperf' size 5000M reuse
maxdatafiles 100
CHARACTER SET US7ASCII;
--NATIONAL CHARACTER SET US7ASCII;

-- ALTER TABLESPACE SYSTEM ADD DATAFILE
-- '&1\oradata\ecperf\cntrlecperf2.dbf' SIZE 150M;

DISCONNECT
connect / as sysdba
create rollback segment r01
	storage (initial 100K minextents 2 next 100K);
create rollback segment r02
	storage (initial 100K minextents 2 next 100K);
create rollback segment r03
	storage (initial 100K minextents 2 next 100K);
create rollback segment r04
	storage (initial 100K minextents 2 next 100K);
create rollback segment r05
	storage (initial 100K minextents 2 next 100K);
create rollback segment r06
	storage (initial 100K minextents 2 next 100K);
create rollback segment r07
	storage (initial 100K minextents 2 next 100K);
create rollback segment r08
	storage (initial 100K minextents 2 next 100K);
create rollback segment r09
	storage (initial 100K minextents 2 next 100K);
create rollback segment r10
	storage (initial 100K minextents 2 next 100K);
create rollback segment r11
	storage (initial 100K minextents 2 next 100K);
create rollback segment r12
	storage (initial 100K minextents 2 next 100K);
create rollback segment r13
	storage (initial 100K minextents 2 next 100K);
create rollback segment r14
	storage (initial 100K minextents 2 next 100K);
create rollback segment r15
	storage (initial 100K minextents 2 next 100K);
create rollback segment r16
	storage (initial 100K minextents 2 next 100K);
create rollback segment r17
	storage (initial 100K minextents 2 next 100K);
create rollback segment r18
	storage (initial 100K minextents 2 next 100K);
create rollback segment r19
	storage (initial 100K minextents 2 next 100K);
create rollback segment r20
	storage (initial 100K minextents 2 next 100K);

DISCONNECT
CONNECT / as sysdba

shutdown
startup pfile=&2\dbs\p_build_ecperf.ora

--CONNECT sys/change_on_install
--CONNECT / as sysdba
@&2\rdbms\admin\catalog;
@&2\rdbms\admin\catexp.sql
@&2\rdbms\admin\catldr.sql
@&2\rdbms\admin\catproc.sql
DISCONNECT;

CONNECT / as sysdba
CREATE USER ecperf IDENTIFIED BY ecperf;
GRANT CONNECT, RESOURCE TO ecperf;
DISCONNECT;

CONNECT system/manager
CREATE TEMPORARY TABLESPACE temp_space
	TEMPFILE '&1\oradata\ecperf\temp_ecperf' SIZE 2000M;
DISCONNECT;

CONNECT / as sysdba
ALTER USER ecperf
	TEMPORARY TABLESPACE temp_space ;
--	DEFAULT TABLESPACE temp_space;
DISCONNECT;

CONNECT system/manager
CREATE UNDO TABLESPACE roll_space
	DATAFILE '&1\oradata\ecperf\roll_ecperf' SIZE 2048M;
DISCONNECT;

-- 2002.12.21 
-- CONNECT system/manager
-- CREATE TABLESPACE  stats_space
--	TEMPFILE '&1\oradata\ecperf\stats_ecperf' SIZE 200M;
-- DISCONNECT;

spool off

quit;
