(Like all platforms...) its always good to use DBCA to "generate creation scripts" and then peruse the scripts to see how its all going to hang together. Cheers Connor -- Connor McDonald =========================== email: connor_mcdonald@xxxxxxxxx web: http://www.oracledba.co.uk "Semper in excremento, sole profundum qui variat"