- There are synonyms in database schema with millions of rows which get updated incrementally each day at 6 AM CEST.
- I want to write a stored procedure which looks at the last modified date in the source table which changes whenever the tables gets updated.
- Now if the last modified date s changed then i want to copy the newly added data to the destination tables.
- After the copying is finished i want to maintain a log file of the number of rows that have been copied each day
- Both the schemas are oracle but different connections
- The database is 19c