Home » SQL & PL/SQL » SQL & PL/SQL » FLASHBACK QUERY (11g r2)
FLASHBACK QUERY [message #608119] Sun, 16 February 2014 09:01 Go to next message
mvrkr44
Messages: 54
Registered: December 2012
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 Go to previous messageGo to next message
BlackSwan
Messages: 22808
Registered: January 2009
Senior Member
mvrkr44 wrote on Sun, 16 February 2014 07:01
i 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 #608122 is a reply to message #608120] Sun, 16 February 2014 10:37 Go to previous messageGo to next message
mvrkr44
Messages: 54
Registered: December 2012
Member
and 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
Re: FLASHBACK QUERY [message #608125 is a reply to message #608122] Sun, 16 February 2014 11:16 Go to previous messageGo to next message
BlackSwan
Messages: 22808
Registered: January 2009
Senior Member
are all the prerequisites met?

http://docs.oracle.com/cd/E16655_01/backup.121/e17630/rcmflash.htm#BRADV81517
Re: FLASHBACK QUERY [message #608126 is a reply to message #608125] Sun, 16 February 2014 11:19 Go to previous messageGo to next message
mvrkr44
Messages: 54
Registered: December 2012
Member
yes,all pre requisites has given,
undo_retention has given 24 hours...
Re: FLASHBACK QUERY [message #608134 is a reply to message #608122] Sun, 16 February 2014 18:42 Go to previous messageGo to next message
John Watson
Messages: 4592
Registered: January 2010
Location: Global Village
Senior Member
mvrkr44 wrote on Sun, 16 February 2014 16:37
and 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 #608139 is a reply to message #608134] Mon, 17 February 2014 00:00 Go to previous messageGo to next message
mvrkr44
Messages: 54
Registered: December 2012
Member
hi,

Then how can i perform flashback table operation.
could you pls help
Re: FLASHBACK QUERY [message #608178 is a reply to message #608139] Mon, 17 February 2014 03:41 Go to previous message
John Watson
Messages: 4592
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>
Previous Topic: SQL gets not result in Ora Enterprise 11.1.0.7.0 but in 10 and 11 XE it does
Next Topic: ORDER BY the day of the week
Goto Forum:
  


Current Time: Tue Sep 23 16:17:02 CDT 2014

Total time taken to generate the page: 0.08199 seconds