In SQLServer TRUNCATE TABLE can be rolled back when within a transaction. TRUNCATE still doesn't log each row when it's deleting each row and it doesn't call DELETE trigger during truncate. Example: BEGIN TRANSACTION SELECT count(*) FROM test TRUNCATE TABLE test SELECT count(*) FROM test ROLLBACK TRAN SELECT count(*) FROM test Output: ----------- 2 (1 … Continue reading Truncate statement in SQLSever
Tag: rollback
How to terminate and rollback a SQL script when running in SQL*Plus when an error is encountered?
Adding the following line before running a SQL Script will terminate the SQL script from running and rollback the change when an error is encountered. WHENEVER SQLERROR EXIT SQL.SQLCODE ROLLBACK; Example: SQL> select * FROM test; no rows selected SQL> WHENEVER SQLERROR EXIT SQL.SQLCODE ROLLBACK; SQL> insert into test values ( 1 ); 1 row … Continue reading How to terminate and rollback a SQL script when running in SQL*Plus when an error is encountered?
Change from Rollback Segments 8i to UNDO in 9i/10g
Created UNDO tablespace CREATE UNDO TABLESPACE undotbs DATAFILE '/ora_data_1/GIST/oradata/undotbs_01.dbf' SIZE 100M REUSE AUTOEXTEND ON; ALTER DATABASE DATAFILE '/ora_data_1/GIST/oradata/undotbs_01.dbf' RESIZE 3000M; shutdown immediate; Changed UNDO parameters in the init file Make sure COMPATIBLE=9.0.2 in the init.ora file is set. ### ROLLBACK SEGMENTS ### undo_management = AUTO undo_tablespace = UNDOTBS undo_retention = 1800 Comment out RBS parameters … Continue reading Change from Rollback Segments 8i to UNDO in 9i/10g
alexlima.com 