Home » SQL & PL/SQL » SQL & PL/SQL » Flashback Truncated Table (oracle 10g)
Flashback Truncated Table [message #425410] Fri, 09 October 2009 01:41 Go to next message
ramesh55.sse
Messages: 262
Registered: December 2008
Location: Hyderabad
Senior Member
Is it possible to bring back the truncated Table using flashback query.
if it is possible please give me the query.
Re: Flashback Truncated Table [message #425412 is a reply to message #425410] Fri, 09 October 2009 01:48 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It is not possible.
You cannot flashback across DDL.

Regards
Michel
Re: Flashback Truncated Table [message #425415 is a reply to message #425410] Fri, 09 October 2009 01:51 Go to previous messageGo to next message
ramesh55.sse
Messages: 262
Registered: December 2008
Location: Hyderabad
Senior Member
you said thst flash black not possiDDL , but we can flashback a droped table.
Re: Flashback Truncated Table [message #425434 is a reply to message #425415] Fri, 09 October 2009 02:41 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is NOT a flashback query and you asked for this.
Anyway, using recycle bin you can flashback a dropped table, there is no recycle bin for truncate (currently).

Regards
Michel
Previous Topic: BUlk Delete
Next Topic: need in oracle
Goto Forum:
  


Current Time: Wed Dec 07 23:56:19 CST 2016

Total time taken to generate the page: 0.09659 seconds