FLASHBACK TABLE <table_name> to BEFORE DROP;


Deepthi Samarasinghe
Database Architect


-----Original Message-----
From: Shaju J. Joseph
[mailto:oracledba-ezmlmshield-x52476026.[Email address protected]
Sent: Tuesday, November 28, 2006 4:30 AM
To: LazyDBA Discussion
Subject: getting back

Hi Gurus





One of our developers has truncated a table in a 10g Database. Which
is in no archive log mode. How can I retrieve it through FLASHBACK QUERY
. Is there any way to get it back??



Thanking you



--Joseph



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To post a
dba job: http://jobs.lazydba.com To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


Oracle LazyDBA home page