Truncated Table
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Truncated Table

  1. #1
    Join Date
    Jun 2007
    Posts
    42

    Truncated Table

    OS : Oracle 10g on Windows 2003.
    Suppose If I have taken a full database backup. After that I truncated a table from production DB.If the media failures and if I want to recover my data in this situation, will the truncated table will be available still after recovery,since it is creating no logs?.Just doubt.sorry If I am asking a silly question.

    Thanks in advance.
    A learning DBA.

    Shihab

  2. #2
    Join Date
    Nov 2002
    Location
    Mooresville, NC
    Posts
    349
    Since you have taken a full database back up and after that you are truncating a table, then you should able to restore because you have everything in the backup. But if you want to roll forward you can not since your database is in no archive mode.
    http://www.perf-engg.com
    A performance engineering forum

  3. #3
    Join Date
    Jul 2002
    Location
    Northampton, England
    Posts
    612
    ... and if you were in archivelog mode, you'd have to remember to rollforward to just before the point that you trucated your table using SCN/Sequence/Time to ensure you didn't truncate your table all over again.

    Some urgent reading is required me thinks (tahiti.oracle.com).
    Assistance is Futile...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width