PL/SQL (MOSC)

MOSC Banner

Does truncate and drop statement clean the disk with 0s or would it be possible to recover data thro

edited Feb 22, 2018 12:26PM in PL/SQL (MOSC) 5 commentsAnswered ✓

Hi,

Our security team is asking us if using truncate or drop statements also wipes the disk.

They are interested to know if, should someone get their hands on a disk belonging to the DB, if they could use forensic methods to obtain data from a table which was truncated or dropped from the DB.

So it's possible it would be deleted from a user perspective but still available on disk until overwritten.

Thanks,

Nico

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center