Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How do I ensure no 'ghost' data exists for a row on a datafile?

Chris DJJul 28 2015 — edited Aug 6 2015

Even after committing the delete of a row in a table, the 'ghost' data remains on the datafile.

The 'ghost' data could potentially be accessed by a malicious user, circumventing the database access controls, using a hex editor on the datafile.

Short of moving the table (and all other segments) into a new tablespace and then shredding the old datafile, how can I securely delete a specific row?

Regards

Chris

This post has been answered by Vlad Visan-Oracle on Jul 28 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 3 2015
Added on Jul 28 2015
11 comments
1,981 views