Home » SQL & PL/SQL » SQL & PL/SQL » Rollback issue
Rollback issue [message #589723] Wed, 10 July 2013 06:27 Go to next message
bvsr
Messages: 3
Registered: July 2013
Location: hyderabad
Junior Member
I have created one table and rollback that tabe,can i get the table again?
Re: question [message #589725 is a reply to message #589723] Wed, 10 July 2013 06:28 Go to previous messageGo to next message
cookiemonster
Messages: 10961
Registered: September 2008
Location: Rainy Manchester
Senior Member
rollback doesn't affect create table (or any ddl statement). What did you really do?
Re: question [message #589726 is a reply to message #589723] Wed, 10 July 2013 06:28 Go to previous messageGo to next message
Michel Cadot
Messages: 59203
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You cannot rollback a table creation.

Regards
Michel
Re: question [message #589727 is a reply to message #589725] Wed, 10 July 2013 06:29 Go to previous messageGo to next message
bvsr
Messages: 3
Registered: July 2013
Location: hyderabad
Junior Member
i m asking about inserting data
Re: question [message #589728 is a reply to message #589727] Wed, 10 July 2013 06:30 Go to previous messageGo to next message
bvsr
Messages: 3
Registered: July 2013
Location: hyderabad
Junior Member
i have inserted values into the table and without commit i rollback how can i get data
Re: question [message #589731 is a reply to message #589728] Wed, 10 July 2013 06:36 Go to previous message
cookiemonster
Messages: 10961
Registered: September 2008
Location: Rainy Manchester
Senior Member
you can't.
Previous Topic: Inner and outer loop in cursor
Next Topic: Bulk insert in index table
Goto Forum:
  


Current Time: Tue Sep 23 15:59:28 CDT 2014

Total time taken to generate the page: 0.10391 seconds