Forum Stats

  • 3,874,709 Users
  • 2,266,767 Discussions
  • 7,911,957 Comments

Discussions

Is there any way we can define TTL for Oracle Autonomous Database?

Answers

  • asahide
    asahide Expert Technical Engineer Member Posts: 1,503 Gold Trophy

    Hi,

    Oracle relational database does not have it out of the box.

    You have usually scheduled a stored procedure to perform such tasks.

    delete from table where CreatedAt < sysdate - 1
    

    Regards,