Hi Tim, > Your script looks nicer and neat. I probably will just add a spool and use > yours going forward. Thanks! Me too! However I've had to modify it to remove the union all and replace then with a ';' to separate out all the statements. This is because when one statement fails, say there are no tablespace quotas for example, you don't get the remainder of the script generated. Thanks again though, good script. Cheers, Norm. -- Norman Dunbar Dunbar IT Consultants Ltd Registered address: Thorpe House 61 Richardshaw Lane Pudsey West Yorkshire United Kingdom LS28 7EL Company Number: 05132767 -- //www.freelists.org/webpage/oracle-l