That is one of the main prerequisites for flashback.

It should be in ARCHIVELOG mode.





-----Original Message-----
From: Shaju J. Joseph
[mailto:oracledba-ezmlmshield-x39498900.[Email address protected]
Sent: Wednesday, 29 November 2006 4:07 PM
To: LazyDBA Discussion
Subject: FW: FW: getting back


I doont think that the database should be in archive mode. But
UNDO_RETENTION should be mentioned properly. Am I right??

--Joseph

-----Original Message-----
From: Parveen Kumar [mailto:oracledba-ezmlmshield-x77625932.[Email
address protected]
Sent: Wednesday, November 29, 2006 8:17 AM
To: LazyDBA Discussion
Subject: Re: FW: getting back

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
>
>



---------------------------------------------------------------------
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



________________________________________________________________________
This email has been scanned for viruses by the CITEC Email Anti-Virus
service powered by MessageLabs. For more information on a proactive
email anti-virus service working around the clock, around the globe,
visit www.citec.com.au
________________________________________________________________________

--------------------------------------------------------

This email and associated attachments may contain confidential and privileged CITEC information that is provided solely for the use of the intended addressee. Views and opinions expressed in this email are those of the individual sender and are not necessarily the views and opinions of CITEC unless the sender expressly states that such views and opinions are those of CITEC. The privilege and confidentiality associated with this email and attachments will not be waived, lost or rescinded by reason of mistaken delivery. Should you receive this email by mistake, please notify the sender by return email then delete the email from your computer system. You must not use, copy, modify, print, or distribute the email or the information and attachments contained within same to any third party. CITEC does not accept any liability in respect of viruses or computer problems experienced by the recipient through access gained to this email and its attachments.
--------------------------------------------------------

________________________________________________________________________
This email has been scanned for viruses by the CITEC Email Anti-Virus service powered by MessageLabs. For more information on a proactive email anti-virus service working around the clock, around the globe, visit www.citec.com.au
________________________________________________________________________

Oracle LazyDBA home page