Re: Flashback over database link

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

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. Received on Thu Mar 10 2005 - 10:02:40 CET