Hi Kavitha,

You can get numerous DB creation sample scripts.

But as u say it is for a Site, it ought to be available 24/7.
U got to decide on various parameters based on the number of expected transactions & Hits etc.,

Follow link below... it would give u overview of creating a Database.

http://www.dbasupport.com/oracle/ora...createDB.shtml

Search the archive for more info.,

Cheers
Nandu