Execute the below scripts for Backup Table

Step1:-

“CREATE TABLE scratch.RA_CUST_INT_INC0054156 as select * from apps.RA_CUSTOMERS_INTERFACE_ALL where org_id =****;
/
CREATE TABLE scratch.RA_CUST_PRO_INC0054156 as select * from apps.RA_CUSTOMER_PROFILES_INT_ALL where org_id=****;
/
CREATE TABLE scratch.RA_CUST_PHO_INC0054156 as select * from apps.RA_CONTACT_PHONES_INT_ALL where org_id=****;

Execute the Below Scripts for delete

Step2:-

“Delete from apps.RA_CUSTOMERS_INTERFACE_ALL where org_id =****;
/
Delete from apps.RA_CUSTOMER_PROFILES_INT_ALL where org_id=****;
/
Delete from apps.RA_CONTACT_PHONES_INT_ALL where org_id=****;”

Step3:-  Commit;

Recent Posts

Start typing and press Enter to search