l.armbruester@vertriebsunion.de (Lothar Armbr?ster) wrote in message news:<35559896.0503090437.187780be@posting.google. com>...[color=blue]
> 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[/color]
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.
