create database mydb maxinstances 1 maxloghistory 1 maxlogfiles 5 maxlogmembers 5 maxdatafiles 100 datafile '$oracle_home/oradata/mydb/system01.dbf' size 200m reuse undo tablespace undotbs datafile '$oracle_home/oradata/mydb/undotbs01.dbf' size 200m reuse autoextend on next 2048k maxsize unlimited default temporary tablespace temptbs1 character set zht16big5 national character set al16utf16 logfile group 1 ('$oracle_home/oradata/mydb/redo01.log') size 100m, group 2 ('$oracle_home/oradata/mydb/redo02.log') size 100m, group 3 ('$oracle_home/oradata/ora901/redo03.log') size 100m;