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 maxinstances 1 maxlogfiles 6 maxloghistory 100 maxdatafiles 64 noarchivelog datafile '/home/oracle/oradata/system01.dat' size 16m autoextend on next 8m maxsize 320m sysaux datafile '/home/oracle/oradata/sysaux.dat' size 16m autoextend on next 8m maxsize 320m default temporary tablespace temp tempfile '/home/oracle/oradata/temp01.dat' size 16m extent management local uniform size 512k undo tablespace undo datafile '/home/oracle/oradata/undo01.dat' size 16m autoextend off; @rdbms/admin/catalog @rdbms/admin/catproc 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.dat' AUTOEXTEND OFF; alter database DATAFILE '/home/oracle/oradata/sysaux.dat' AUTOEXTEND OFF;