set echo on
spool create.log
connect internal
startup nomount
create database LXO
	controlfile reuse
	maxlogfiles 3
	maxlogmembers 2
	maxloghistory 64
	maxdatafiles 128
	maxinstances 1
	noarchivelog
	character set we8iso8859p1
	national character set we8iso8859p1
	logfile
		group 1
			('/app/lxo_data/log1/log11LXO.dbf',
			 '/app/lxo_data/log2/log12LXO.dbf') size 4m reuse,
		group 2
			('/app/lxo_data/log1/log21LXO.dbf',
			 '/app/lxo_data/log2/log22LXO.dbf') size 4m reuse,
		group 3
			('/app/lxo_data/log1/log31LXO.dbf',
			 '/app/lxo_data/log2/log32LXO.dbf') size 4m reuse
	datafile
		'/app/lxo_data/tab/system01LXO.dbf' size 64m reuse
			autoextend on next 4m
/
create tablespace temp
	datafile '/app/lxo_data/tab/temp01LXO.dbf' size 4m reuse
		autoextend on next 2m maxsize 64m
/
create tablespace rbs
	datafile '/app/lxo_data/tab/rbs01LXO.dbf' size 10m reuse
		autoextend on next 2m maxsize 64m
/
create public rollback segment rbs01
	tablespace rbs
	storage ( initial 512k next 256k minextents 2 maxextents 121
		optimal 1m )
/
alter rollback segment rbs01 online
/
create public rollback segment rbs02
	tablespace rbs
	storage ( initial 512k next 256k minextents 2 maxextents 121
		optimal 1m )
/
alter rollback segment rbs02 online
/
create tablespace users
	datafile '/app/lxo_data/tab/users01LXO.dbf'
	size 4m reuse
	autoextend on next 2m
/
alter user sys identified by clown
/
alter user system identified by clown temporary tablespace temp
/
spool off
