CREATE DATABASE orcl
CONTROLFILE REUSE
character set utf8
national character set utf8
LOGFILE
	GROUP 1 ('/home/oracle/oradata/log1') SIZE 8M,
	GROUP 2 ('/home/oracle/oradata/log2') SIZE 8M
MAXLOGFILES 10
DATAFILE '/home/oracle/oradata/system01.dbf' SIZE 16M
	AUTOEXTEND ON NEXT 8M MAXSIZE 320M
MAXDATAFILES 15;

@rdbms/admin/catalog

@rdbms/admin/catproc

create temporary tablespace temp tempfile
        '/home/oracle/oradata/temp01.dbf' size 8M
	extent management local uniform size 512k;

create tablespace foo datafile '/home/oracle/oradata/foo.dbf' size 1m;
create rollback segment foorb tablespace foo;
alter rollback segment foorb online;

create tablespace rbs datafile '/home/oracle/oradata/rbs01.dbf' size 8M
	extent management local uniform size 512k;

create rollback segment r01 tablespace rbs;
create rollback segment r02 tablespace rbs;

alter rollback segment r01 online;
alter rollback segment r02 online;

alter rollback segment foorb offline;
drop rollback segment foorb;
drop tablespace foo;
!rm /home/oracle/oradata/foo.dbf

create tablespace users datafile '/home/oracle/oradata/users.dbf' size 8M
	AUTOEXTEND ON NEXT 8M MAXSIZE 320M
	extent management local uniform size 512k;

alter database DATAFILE '/home/oracle/oradata/system01.dbf' AUTOEXTEND OFF;

create user luser identified by luserpassword
	default tablespace users temporary tablespace temp;