answer embedded.
--
Have a nice day
Michel
"nick" <nmudie_at_chello.com> a écrit dans le message news:
Hngs7.8592$8m2.584534_at_amsnews02.chello.com...
> Hi folks,
>
> what's the easiest way to replicate a table from a remote database every day
> at 5am??
>
> SNAPSHOT VIEW??? can you give me an example?
CREATE MATERIALIZED VIEW my_snap
REFRESH START WITH SYSDATE
NEXT TRUNC(SYSDATE+1) + 5/24
AS SELECT * FROM my_table_at_my_remote_db;
>
> DBLINK??
>
> Many thanks,
> Nick
>
> Apllications Engineer
> Chello Broadband
> nmudie_at_chello.com
>
>
Received on Wed Sep 26 2001 - 04:31:27 CDT
