use this link to recover truncated table

http://luhartma.blogspot.com/2006/01/flashback-any-error-with-oracle-10g_23.html

Parveen

Shaju J. Joseph wrote:
> Hi
>
> I think we can rollback to time which is specified with
> UNDO_RETENTION. The value is in seconds.
>
> When I tried FLASHBACK TABLE <table_name> AS OF TIMESTAMP , it
> gives an error
>
> ERROR at line 1:
> ORA-01466: unable to read data - table definition has changed.
>
> --Joseph
>
>
> -----Original Message-----
> From: Samarasinghe Deepthi
> [mailto:oracledba-ezmlmshield-x48477107.[Email address protected]
> Sent: Tuesday, November 28, 2006 6:22 PM
> To: LazyDBA Discussion
> Subject: RE: getting back
>
> If the table is truncated then you can use:
> FLASHBACK TABLE <table_name> AS OF TIMESTAMP <
>
>
> Deepthi Samarasinghe
> Database Architect
>
> -----Original Message-----
> From: Samarasinghe Deepthi
> [mailto:oracledba-ezmlmshield-x85795877.[Email address protected]
> Sent: Tuesday, November 28, 2006 9:48 AM
> To: LazyDBA Discussion
> Subject: RE: getting back
>
> 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
>
>
>
> ---------------------------------------------------------------------
> 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
>
>
>
> ---------------------------------------------------------------------
> 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
>
>
>
>
> ---------------------------------------------------------------------
> 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