create database db1 maxinstances 1 maxloghistory 1 maxlogfiles 5 maxlogmembers 5 maxdatafiles 100 datafile '/oracle/app/oradata1/db1.dbf' size 100m undo tablespace undotds datafile '/oracle/app/oradata1/undodb1.dbf' size 100m autoextend on next 512k maxsize unlimited default temporary tablespace tempts character set us7ascii national character set al16utf16 logfile group 1('/oracle/app/oradata1/redo01.log') size 100m 2('/oracle/app/oradata1/redo02.log') size 100m 3('/oracle/app/oradata1/redo03.log') size 100m;