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
Oracle LazyDBA home page