Sorry couldn't see that your database is in NOARCHIVE mode , so I think
you should forget recovering the table as to use FLASHBACK DATABASE the
database should be in archive log

Parveen

Parveen Kumar wrote:
> 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
>>
>>
>
>
>
> ---------------------------------------------------------------------
> 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