Re: Flahsback archivinging questions
Date: Sun, 03 May 2009 07:13:23 +0200
Message-ID: <of9qv498ntggo0g2h8d57k9dr3niegj69i_at_4ax.com>
On Sat, 2 May 2009 19:12:38 -0700 (PDT), zigzagdna_at_yahoo.com wrote:
>I am using Oracle 11.1.0.6 on Windows XP.
>Flahsback archive
>I have created a flashback archive with retention time of 1 month.
>Table t is in this fb archive.
>1. Now if I change retention time of the fb archive to 1 day, will it
>apply to already inserted data, or it applies only to new data. I
>think it applies to old data as well, bust just checking.
>2. I am looking in dba_flashback_archive_tables, It shows a history
>table SYS_FBA_HIST_70224.
>But when I do select * from SYS_FBA_HIST_70224, table is not found. I
>looked under dba_tables as well, TBALE is not shown, yet it is shown
>in dba_flashback_archive_tables. Where is this table?
1 Questions like this one can be answered in several ways
- by a bit of logical thinking
- by testing it on a test database, and check the outcome
Sadly, you have never done neither. Even worse, you seem to have
changed your strategy. You seem to post all of your queries
a) anonymously on OTN
b) when the answer doesn't arrive quickly enough or sometimes at the
same time, on Usenet, using your nick 'zigzagdna'
You must qualify easily as the DBA who tries spend as little time as
possible on resolving his own questions and dumping it in volunteer
forums always.
Evidently you are a big nuisance, and I wouldn't have responded but
for your annoying change of strategy. STOP IT. Either start doing, for
the first time in your life, your own work, or limit your doc
questions to 1 forum. I can recall your handle and your posting style
on OTN, so I will ignore you.
2 Did you check the definition of the view dba_flashback_archive_tables? Do you requre someone else to find out the definition? Why? Does Flashback work? So why do you even care?
-- Sybrand Bakker Senior Oracle DBAReceived on Sun May 03 2009 - 00:13:23 CDT