Flashback over database link
Date: 9 Mar 2005 04:37:06 -0800
Message-ID: <35559896.0503090437.187780be_at_posting.google.com>
Hello out there,
this morning I had to get some rows via flashback query. Since my undo
retention is just 3h, the undo segments were already aged out.
But I have a physical standby database that is mounted read only
during daytime for report processing etc.
On this one the old data is still available, but I was not able to
pull them over to my primary site.
Here is what I tried:
create table hay_abos_20050309 as
(select * from dt_abo_bezug_at_standby as of timestamp
to_date('08.03.2005 15:15','DD.MM.YYYY HH24:MI') where mandantenkode='HAY');
ERROR at line 1:
ORA-25124: Database link name not allowed.
Okay, then I tried to use dbms_flashback but I was not able to call the procedure over a database link:
begin
dbms_flashback.enable_at_time_at_standby(to_date('08.03.2005
15:21','DD.MM.YYYY HH24:MI'));
end;
/
ERROR at line 1:
ORA-02083: database name has illegal character '¹'
ORA-06553: PLS-707: unsupported construct or internal error [2604]
I can call simple procedures over the database link but obviously calling packaged procedures this way gives an error.
It is Oracle 9.2.0.5.0 on W2k SP4.
Can I use flashback query over a database link? If so, how do I do this?
Many thanks in advance,
Lothar Received on Wed Mar 09 2005 - 13:37:06 CET