Re: Export user DDL and privileges?
From: Norman Dunbar <oracle_at_dunbar-it.co.uk>
Date: Fri, 27 Jul 2012 12:27:55 +0100
Message-ID: <50127B3B.9070802_at_dunbar-it.co.uk>
Hi Tim,
Date: Fri, 27 Jul 2012 12:27:55 +0100
Message-ID: <50127B3B.9070802_at_dunbar-it.co.uk>
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 -- http://www.freelists.org/webpage/oracle-lReceived on Fri Jul 27 2012 - 06:27:55 CDT