Flashback over database link

[Lothar Armbr?ster]

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@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@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

[Carlos]

l.***********@vertriebsunion.de (Lothar Armbr?ster) wrote in message news:<35**************************@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@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@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

From Metalink:

Flashback Table operations are not valid for the following object types:
================================================== =

- Tables that are part of a cluster
- Materialized views
- Advanced Queuing tables
- Static data dictionary tables
- System tables
- Partitions of a table
- Remote tables (via database link) <== Ops!

Cheers.

Carlos.