Home » RDBMS Server » Server Utilities » flashback limit
flashback limit [message #382994] Mon, 26 January 2009 23:27 Go to next message
gaikwadrachit
Messages: 33
Registered: June 2007
Location: mumbai
Member
Hi

Can anyone tell me what is the time limit that an oracle can flashback tables.

if i want to flashback tables to seven days before..is it possible?
what are the parameters it depends upon?
Re: flashback limit [message #382997 is a reply to message #382994] Mon, 26 January 2009 23:35 Go to previous messageGo to next message
Michel Cadot
Messages: 68712
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Oracle version?
Which kind of flashback? In other words, what do you exactly want to do or get?

Regards
Michel
Re: flashback limit [message #383000 is a reply to message #382997] Mon, 26 January 2009 23:39 Go to previous messageGo to next message
gaikwadrachit
Messages: 33
Registered: June 2007
Location: mumbai
Member
i want to flashback my tables to given time

i m using oracle 10g on solaris
Re: flashback limit [message #383031 is a reply to message #383000] Tue, 27 January 2009 00:32 Go to previous messageGo to next message
Littlefoot
Messages: 21822
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
According to Oracle 10g Concepts book,
Quote:
Oracle Database 10g automatically tunes a parameter called the undo retention period. The undo retention period indicates the amount of time that must pass before old undo information—that is, undo information for committed transactions—can be overwritten. The database collects usage statistics and tunes the undo retention period based on these statistics and on undo tablespace size.

I have no experience in that area, but - it appears that Oracle maintains undo retention period and you can't directly set it. Though, you might modify undo tablespace size which might, in turn, implicitly affect undo retention period.

However, I'd suggest you to wait for another opinion.
Re: flashback limit [message #383037 is a reply to message #383000] Tue, 27 January 2009 00:41 Go to previous message
Michel Cadot
Messages: 68712
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
What does flashback mean for you?
There are many kinds of flashback.

Regards
Michel
Previous Topic: SQLLDR Import Time string as seconds
Next Topic: Problem with Tablespace
Goto Forum:
  


Current Time: Tue Nov 12 22:23:15 CST 2024