The following example creates a new database called TEST:
CREATE DATABASE TEST LOGFILE GROUP 1 ('/disk01/oracle/log1.log','/disk02/oracle/log2.log') SIZE 50K, GROUP 2 ('/disk03/oracle/log2.log','/disk04/oracle/log2.log') SIZE 50K MAXLOGFILES 5 DATAFILE '/disk10/oradata/system01.dbf' SIZE 50M MAXDATAFILES 100 ARCHIVELOG