Need help with writting a PL/SQL code
Hello :
I have a requirement to write a PL/SQL code to delete about 9 billion records in small batch of 10,000. The procedure should run permanently and must select the records to delete, back them up to another table, delete them, repeat. This should be set up via a job. All on Oracle 11gR2.
Thanks
E.
8 years ago
20
Answer(1)![blurred-text]()
![]()
Purchase the answer to view it

NOT RATED
- SQL.sql