Oracle Database Discussions

Hello,

According to Oracle documentation, when purging an object in the recycle bin using the original name and when multiple objects of the same name exist, then the object that has been in the recycle bin the longest is purged first (FIFO).

From what I understand, in order to restore an older version of an object, I need to continue to use FLASHBACK TO BEFORE DROP followed by a DROP object PURGE, which does not rename objects to the recycle bin, until I retrieve the version of the table that I want.

Is this correct?

Thanks!