How to delete all the content (Rule & Data) of RAP?
I accidentally imported one RAP (zip file) to my application. Is there any way I can delete all the rules/data of the RAP?
It's huge RAP and I don't want to do it manually.
Cognizant
IN
You can go for a DB restoration and restore it to a specific point of time before you started the import.
Bank of America
IN
Can you please elaborate?
Cognizant
IN
The rules go to some table ideally pr4_rule in rules schema in case of split schema. When you import a package the rules are inserted into your rules table and other tables in case of your data instances . I believe we can restore these tables to an earlier point , it's just that we have to give the time stamp to which we want to restore. Please refer the link below or you can check the DBA in your team for table or schema restoration.
https://blogs.oracle.com/sql/how-to-recover-data-without-a-backup