Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
not able to delete data
Hi All, Trying a simple time-based (< timestamp) delete on a particular table in our database. The total number of records deleted is 1887497. In order to ensure that the delete goes through I am performing manual purging. So the sequence is something like :: a) delete b) select make_ahm_now(); c) select purge_table('table_name'); However the purge command returns instantly and on checking further, the records reappear in the table. This is quite puzzling to me. Any help would be appreciated. The delete_vectors table doesn't contain any records corresponding to the delete performed. Thanks Ravi.