Re: Export user DDL and privileges?
- From: Norman Dunbar <oracle@xxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 27 Jul 2012 12:27:55 +0100
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
Other related posts:
