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