troubleshooting Question

I have 3 table called 1.Sales, 2.sales_copy, 3.sales_log_err respectively i have more than 3 million sales record i want to copy allsales record into sales_copy table and at the same time i wan

Avatar of MIHIR KAR
MIHIR KARFlag for India asked on
Oracle Database
1 Comment1 Solution256 ViewsLast Modified:
I have 3 table
called
 1.Sales,
 2.sales_copy,
 3.sales_log_err
 respectively  i have more than 3 million sales record i want to copy allsales record into sales_copy table and at the same time i want to track all the rejected error data into  table-3 sales_log _err with a sequence number how it is possible in plsql.
Sales_copy table contains some validation constraints i want to filter the data please help.
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros