/*
CREATE DATABASE fathfair
    CHARACTER SET UTF8
    LOGFILE GROUP 1 ('/u01/ilq60/fathfair/redo01.log') SIZE 100M, 
            GROUP 2 ('/u01/ilq60/fathfair/redo02.log') SIZE 100M,
            GROUP 3 ('/u01/ilq60/fathfair/redo03.log') SIZE 100M
    DATAFILE '/u01/ilq60/fathfair/node01/imoku98.dbf' SIZE 100M, 
             '/u01/ilq60/fathfair/node01/imexo28.dbf' SIZE 100M, 
             '/u01/ilq60/fathfair/node03/ubero58.dbf' SIZE 100M
    SYSAUX DATAFILE '/u01/ilq60/fathfair/node03/sor15.dbf' SIZE 100M, 
                    '/u01/ilq60/fathfair/node01/mev14.dbf' SIZE 100M
    UNDO TABLESPACE UNDOTBS1
	  DATAFILE '/u01/ilq60/fathfair/undotbs01.dbf'
          SIZE 200M REUSE
    DEFAULT TABLESPACE USERS
        DATAFILE '/u01/ilq60/fathfair/node01/oboreli545.dbf' SIZE 100M; 
*/
CREATE TABLESPACE TALL_RED_LAKE 
    DATAFILE '/u01/ilq60/fathfair/node02/tallredlake01.dbf' SIZE 100M ,
             '/u01/ilq60/fathfair/node03/tallredlake02.dbf' SIZE 100M,
             '/u01/ilq60/fathfair/node04/tallredlake03.dbf' SIZE 100M,
             '/u01/ilq60/fathfair/node01/tallredlake04.dbf' SIZE 100M;

CREATE TABLESPACE GOOD_BLACK_DATA
    DATAFILE '/u01/ilq60/fathfair/node02/goodblackdata01.dbf' SIZE 100M,
             '/u01/ilq60/fathfair/node04/goodblackdata02.dbf' SIZE 100M;