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: 103
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 Go to previous messageGo to next message
BlackSwan
Messages: 25573
Registered: January 2009
Location: SoCal
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: 103
Registered: December 2012
Senior 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: 25573
Registered: January 2009
Location: SoCal
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: 103
Registered: December 2012
Senior 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: 7027
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: 103
Registered: December 2012
Senior 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: 7027
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: Constraints., (merged 2)
Next Topic: Unique/check constraint on two columns
Goto Forum:
  


Current Time: Sun Aug 20 20:01:19 CDT 2017

Total time taken to generate the page: 0.04805 seconds