Home » SQL & PL/SQL » SQL & PL/SQL » Rollback after truncate
Rollback after truncate [message #6993] Wed, 14 May 2003 16:08 Go to next message
Vivek nath
Messages: 9
Registered: August 2002
Junior Member
Is it possible to rollback after doing truncate on a table.
Re: Rollback after truncate [message #6994 is a reply to message #6993] Wed, 14 May 2003 16:27 Go to previous messageGo to next message
Art Metzer
Messages: 2480
Registered: December 2002
Senior Member
quote from Vivek nath:
----------------------------------------------------------------------
Is it possible to rollback after doing truncate on a table. 

----------------------------------------------------------------------
No.

A
Re: Rollback after truncate [message #7047 is a reply to message #6993] Sun, 18 May 2003 00:20 Go to previous message
Stacey
Messages: 5
Registered: September 2002
Junior Member
No its not possible as truncate deletes the data from the rollback segment .So its not possible to retrieve back the truncated data
Previous Topic: while creating table copied all user defined constraints
Next Topic: ora-01034 oracle not available???? Top urgent
Goto Forum:
  


Current Time: Thu Mar 28 16:02:01 CDT 2024