Re: Export user DDL and privileges?

> 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


--
http://www.freelists.org/webpage/oracle-l