Flahsback archivinging questions
From: <zigzagdna_at_yahoo.com>
Date: Sat, 2 May 2009 19:12:38 -0700 (PDT)
Message-ID: <184a0462-15af-4c77-9011-66eedd968ded_at_l5g2000vbc.googlegroups.com>
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? Received on Sat May 02 2009 - 21:12:38 CDT
Date: Sat, 2 May 2009 19:12:38 -0700 (PDT)
Message-ID: <184a0462-15af-4c77-9011-66eedd968ded_at_l5g2000vbc.googlegroups.com>
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? Received on Sat May 02 2009 - 21:12:38 CDT