Yes, That is right for FLASHBACK DATABASE but if I am not mistaken
FLASHBACK TABLE only needs:
undo_management = auto
undo_tablespace = <Undo_TS_Name>
undo_retention = <n>
Deepthi Samarasinghe
Database Architect
-----Original Message-----
From: Sultan Shiffa
[mailto:oracledba-ezmlmshield-x18120471.[Email address protected]
Sent: Tuesday, November 28, 2006 10:28 AM
To: LazyDBA Discussion
Subject: RE: getting back
Prerequisites for flashback
Archive mode
Alter databse flashback on (in mount state)
Checking
Show parameter flash
Show parameter recoverz
V$FLASHBACK_DATABASE_LOG
To recover DDL and Truncate
SQL> SELECT oldest_flashback_scn, oldest_flashback_time
FROM v$flashback_database_log;
FLASHBACK DATABASE TO SCN
Or
FLASHBACK DATABASE TO TIMESTAMP <timestamp>
Here we go
-----Original Message-----
From: Samarasinghe Deepthi
[mailto:oracledba-ezmlmshield-x48477107.[Email address protected]
Sent: 28 November 2006 16:22
To: LazyDBA Discussion
Subject: RE: getting back
If the table is truncated then you can use:
FLASHBACK TABLE <table_name> AS OF TIMESTAMP <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