This happens if the table is truncated. If it was deleted or dropped
the "FLASHBACK TABLE table TO TIMESTAMP" and "FLASHBACK TABLE table TO
BEFORE DROP" respectively works without the db being on archivelog and
flashback database enabled mode. It only needs UNDO setup. For the
truncated scenario it will need a restore or flashback database
(provided archive mode and flashback database have been enabled). I was
mistaken with the TRUNCATE scenario.
Deepthi Samarasinghe
-----Original Message-----
From: Shaju J. Joseph
[mailto:oracledba-ezmlmshield-x47723606.[Email address protected]
Sent: Wednesday, November 29, 2006 12:05 AM
To: LazyDBA Discussion
Subject: FW: getting back
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