CODEWITHSUNDEEP
oracle-databasetruncateclobrecover
Astroy 9119
Astroy 9119

Reputation: 1

Oracle Recover Clob data after truncate table

Is there any way to recover a table that contains CLOB data after truncation? I have accidentally truncated PROD data and would like to recover it back.

Upvotes: 0

Views: 200

Answers (1)

pmdba
pmdba

Reputation: 7043

Truncate removes all data from a table without recording a delete transaction. There is no way to recover that data with a rollback or "as of" query. The only way to recover your data would be from a backup of the database - either a datapump dump or RMAN backup - made before the truncate command was issued.

Upvotes: 1

Related Questions