Need help with writting a PL/SQL code

profileobeym

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)

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      SQL.sql