Oracle Database Discussions

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!

i want to know when we issue truncate table statement in oracle .

ibneyDec 29 2012 — edited Jan 3 2013

i want to know when we issue truncate table statement in oracle .No log will be write in redo log .But we can recover data using flashback or scn.I want to know where is the actually truncate table statement log is stored in oracle database.Please explain me in detail step by step .

This post has been answered by unknown-7404 on Jan 2 2013

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 31 2013

Added on Dec 29 2012

#general-database-discussions

16 comments

2,518 views