create controlfile set database PGDWH
logfile
'/u2a3/oradata/DWH6/log4a.dbf' size 128M,
'/u2a3/oradata/DWH6/log1b.dbf' size 128M,
'/u2a4/oradata/DWH6/log4b.dbf' size 128M,
'/u2a4/oradata/DWH6/log2a.dbf' size 128M,
'/u1a2/oradata/DWH6/log3b.dbf' size 128M,
'/u2b3/oradata/DWH6/log2b.dbf' size 128M,
'/u2b3/oradata/DWH6/log3a.dbf' size 128M,
'/u1b1/oradata/DWH6/log1a.dbf' size 128M
resetlogs
datafile
'/u2a4/oradata/DWH6/invx6.dbf' size 1400M,
'/u2a4/oradata/DWH6/invx5.dbf' size 1400M,
'/u1b2/oradata/DWH6/mrpd2.dbf' size 1200M,
'/u1b2/oradata/DWH6/mrpx2.dbf' size 1200M,
'/u2a3/oradata/DWH6/wipd.dbf' size 1200M,
'/u2a3/oradata/DWH6/mrpd.dbf' size 1200M,
'/u2b4/oradata/DWH6/resd.dbf' size 1200M,
'/u2b4/oradata/DWH6/fndd.dbf' size 1100M,
'/u1b1/oradata/DWH6/invd3.dbf' size 1000M,
'/u1b1/oradata/DWH6/invd6.dbf' size 1000M,
'/u4be/oradata/DWH6/resd3.dbf' size 1000M,
'/u4be/oradata/DWH6/pod.dbf' size 1000M,
'/u2b3/oradata/DWH6/glx.dbf' size 1000M,
'/u2b3/oradata/DWH6/resd2.dbf' size 1000M,
'/u1a1/oradata/DWH6/cusd.dbf' size 1000M,
'/u1a1/oradata/DWH6/wipx.dbf' size 1000M,
'/u1a2/oradata/DWH6/mrpx.dbf' size 1000M,
'/u1a2/oradata/DWH6/gld.dbf' size 900M,
'/u1b2/oradata/DWH6/invx.dbf' size 800M,
'/u1b2/oradata/DWH6/othd.dbf' size 800M,
'/u2a3/oradata/DWH6/invd2.dbf' size 800M,
'/u2a3/oradata/DWH6/temp.dbf' size 800M,
'/u2a4/oradata/DWH6/invd4.dbf' size 800M,
'/u2a4/oradata/DWH6/invx8.dbf' size 800M,
'/u2b4/oradata/DWH6/invd5.dbf' size 800M,
'/u1b1/oradata/DWH6/invd.dbf' size 800M,
'/u1b1/oradata/DWH6/invx4.dbf' size 800M,
'/u4be/oradata/DWH6/invx2.dbf' size 800M,
'/u4be/oradata/DWH6/system.dbf' size 700M,
'/u2b4/oradata/DWH6/invx7.dbf' size 600M,
'/u2b3/oradata/DWH6/ard.dbf' size 600M,
'/u2b3/oradata/DWH6/apd.dbf' size 600M,
'/u1a1/oradata/DWH6/oed.dbf' size 600M,
'/u1a1/oradata/DWH6/fad.dbf' size 600M,
'/u1b2/oradata/DWH6/bomd2.dbf' size 600M,
'/u1b2/oradata/DWH6/bomd.dbf' size 600M,
'/u1a2/oradata/DWH6/pox.dbf' size 600M,
'/u2a3/oradata/DWH6/bomx2.dbf' size 600M,
'/u2a3/oradata/DWH6/rbs2.dbf' size 600M,
'/u2a4/oradata/DWH6/rbs.dbf' size 600M,
'/u2a4/oradata/DWH6/invx3.dbf' size 600M,
'/u1a2/oradata/DWH6/arx.dbf' size 600M,
'/u2b4/oradata/DWH6/fndd2.dbf' size 500M,
'/u2b3/oradata/DWH6/mrpd3.dbf' size 400M,
'/u2b3/oradata/DWH6/gld2.dbf' size 400M,
'/u4be/oradata/DWH6/bomx.dbf' size 400M,
'/u2b4/oradata/DWH6/fndx.dbf' size 400M,
'/u1a1/oradata/DWH6/othx.dbf' size 400M,
'/u1a1/oradata/DWH6/apx.dbf' size 400M,
'/u1b1/oradata/DWH6/engd.dbf' size 300M,
'/u1b1/oradata/DWH6/fax.dbf' size 300M,
'/u4be/oradata/DWH6/oex.dbf' size 300M,
'/u1b2/oradata/DWH6/cus2d.dbf' size 200M,
'/u1b2/oradata/DWH6/engx.dbf' size 200M,
'/u1a2/oradata/DWH6/cusx.dbf' size 200M,
'/u1b1/oradata/DWH6/nvd.dbf' size 100M,
'/u2a3/oradata/DWH6/cus2x.dbf' size 100M,
'/u2a3/oradata/DWH6/fcrd.dbf' size 50M,
'/u1b2/oradata/DWH6/mcsd.dbf' size 10M,
'/u1b2/oradata/DWH6/fcrx.dbf' size 5M
maxdatafiles 128
;