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.
Posted: 2 years ago
Posted: 2 years ago
Can you please elaborate?
Posted: 2 years ago
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
You can go for a DB restoration and restore it to a specific point of time before you started the import.