FLASHBACK QUERY [message #608119] |
Sun, 16 February 2014 09:01 |
|
mvrkr44
Messages: 132 Registered: December 2012
|
Senior Member |
|
|
i need a procedure to create a table for every ten minutes,based on the flashback recovery time......
|
|
|
Re: FLASHBACK QUERY [message #608120 is a reply to message #608119] |
Sun, 16 February 2014 09:05 |
|
BlackSwan
Messages: 26766 Registered: January 2009 Location: SoCal
|
Senior Member |
|
|
mvrkr44 wrote on Sun, 16 February 2014 07:01i need a procedure to create a table for every ten minutes,based on the flashback recovery time......
You need to normalize the data & not have any table based upon date/time.
This approach is fatally flawed & should be abandoned immediately!
what problem are you really trying to solve?
Please read and follow the forum guidelines, to enable us to help you:
http://www.orafaq.com/forum/t/88153/0/
[Updated on: Sun, 16 February 2014 09:08] Report message to a moderator
|
|
|
|
|
|
Re: FLASHBACK QUERY [message #608134 is a reply to message #608122] |
Sun, 16 February 2014 18:42 |
John Watson
Messages: 8930 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
mvrkr44 wrote on Sun, 16 February 2014 16:37and one more question..
how we can findfor table minimum flashback recovery time....
when i tried below query
SELECT OLDEST_FLASHBACK_SCN, OLDEST_FLASHBACK_TIME
FROM V$FLASHBACK_DATABASE_LOG;
output :OLDEST_FLASHBACK_SCN OLDEST_FLASHBACK
------------- ----------------
411010 2007/02/14 16:49
but i can't get the data for this flashback time for a particular table...is there any way exactly to know..how we can get the flashback time for that particular table You are confused about how flashback works. The query you have run shows the limit for a flashback database operation (which uses flashback logs), but you are trying to perform a flashback table operation (which uses undo segments). There is no connection between the two.
|
|
|
|
Re: FLASHBACK QUERY [message #608178 is a reply to message #608139] |
Mon, 17 February 2014 03:41 |
John Watson
Messages: 8930 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
It is hard to assist hen you have not explained what you are trying to achieve. All I can suggest is that you look up the syntax, which is very simple. For example:orclz>
orclz> flashback table emp to timestamp (systimestamp - interval '10' minute);
Flashback complete.
orclz>
|
|
|