Home Forums SQL Server 2005 Working with Oracle I have a question about oracle RE: I have a question about oracle

  • May 3, 2012 at 2:33 pm

    #1483342

    PaulB-TheOneAndOnly (5/3/2012)

    Lynn Pettis (5/2/2012)

    Question. We know that TRUNCATE TABLE in SQL Server can be rolled back if inside a transaction. How about in Oracle?

    Can't rollback TRUNCATE in the Oracle world.

    Oracle's TRUNCATE is a DDL operation as opposed to a DML operation; it works at the catalog level reseting the high water mark of the affected table, it generates no redo log at all.

    I'm wondering if this why people think the TRUNCATE TABLE in SQL Server can't be rolled back?

    Thanks for the info, I'll tuck it away for future reference.