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;