Re: Data Masking errors during script
- From: Marcin Przepiorowski <pioro1@xxxxxxxxx>
- To: backseatdba@xxxxxxxxx
- Date: Thu, 12 Mar 2015 08:03:10 +0000
Hi,
Do you have a latest version of database plugins ?
I used to have some issues in early version of DB plugin - if I remember
correctly PSU bundle for EM 12c from October 2014 fixed some issues for
Data Masking.
DM scripts are PL/SQL ones and IIRC they are generating logs when running.
I doubt there is a logic inside which allow you to skip errors, at least it
wasn't a case when I was looking into that.
regards,
Marcin
On Tue, Mar 10, 2015 at 10:01 PM, Jeff Chirco <backseatdba@xxxxxxxxx> wrote:
> Ok I need some help with the data masking scripts generated from EM. I
> pre-generate the masking scripts and then run them on my clone database.
> However if it happens to run into an error when recompiling a referenced
> procedure the whole script will stop. Is there a way to allow the script
> to continue on so it doesn't leave the database in an inconsistent state?
>
> I even sometimes have problems where I generate two scripts, say one for
> SSN and another one that does all birth dates. I run SSN one first and it
> will revoke all grants and at the end is supposed to reply those grants.
> Well for some reason it misses a grant but there is not error. And then
> when the birth date script runs a procedure will error out compiling
> because it needed that grant that the previous script missing reapplying.
>
> Masking scripts are becoming a pain.
>
> Thanks,
> Jeff
>
--
Marcin Przepiorowski
http://oracleprof.blogspot.com
Other related posts:
