This discussion is archived
1 2 Previous Next 16 Replies Latest reply: Jan 3, 2013 7:51 AM by ibney Go to original post RSS
  • 15. Re: i want to know when we issue truncate table statement in oracle .
    rp0428 Guru
    Currently Being Moderated
    >
    I understand your ans.But i want to know where is the stored truncate statement log.But in the redo log no entry for truncate.but i want to from which log it is reversing value..
    >
    If you are still asking after being given the answer then you don't 'understand'.

    You were given the answer above. The flashback archive stores the data.

    See the link that was provided above for CREATE FLASHBACK ARCHIVE in the SQL Language doc
    http://docs.oracle.com/cd/E11882_01/server.112/e26088/statements_5010.htm
    >
    TABLESPACE Clause

    Specify the tablespace where the archived data for this flashback data archive is to be stored. You can specify only one tablespace with this clause. However, you can subsequently add tablespaces to the flashback data archive with an ALTER FLASHBACK ARCHIVE statement.
    >
    The data is moved to the archive tablespace and restored from there when you do a flashback archive query.
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points