Home » Server Options » Replication » replicate to 2 database using snapshots log (Oracle 8i - Windows)
replicate to 2 database using snapshots log [message #285446] Tue, 04 December 2007 11:46 Go to next message
jlebars
Messages: 2
Registered: December 2007
Location: nantes
Junior Member
I have a table MYTABLE in database mydb1 duplicated via materialized view and materialized view log and refresh_snapshot commands to a MYTABLE on mydb2 database.

I like to duplicate this table MYTABLE to a third database mydb2, using the same method (materialized view and refresh_snapshot command).

Is it possible ?

What's hapend to the materialized view log where I launch a refresh_snapshots on mydb2 ? How is this materialized view log truncated ?
Re: replicate to 2 database using snapshots log [message #285447 is a reply to message #285446] Tue, 04 December 2007 11:52 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:

Is it possible ?

Yes.

Quote:

What's hapend to the materialized view log where I launch a refresh_snapshots on mydb2 ? How is this materialized view log truncated ?

It is not truncated, rows are deleted up to the oldest data not refreshed in all targets.

Regards
Michel
Re: replicate to 2 database using snapshots log [message #285524 is a reply to message #285447] Wed, 05 December 2007 00:00 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Quote:

What's hapend to the materialized view log where I launch a refresh_snapshots on mydb2 ? How is this materialized view log truncated ?


Once you transfered data (refresh from materialized view end) next time all materialized view log deleted (It's not truncated).

Babu
Re: replicate to 2 database using snapshots log [message #285563 is a reply to message #285524] Wed, 05 December 2007 01:16 Go to previous messageGo to next message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What your answer adds to mine apart wrong information?

Regards
Michel
Re: replicate to 2 database using snapshots log [message #285597 is a reply to message #285447] Wed, 05 December 2007 02:15 Go to previous messageGo to next message
jlebars
Messages: 2
Registered: December 2007
Location: nantes
Junior Member
Thank sfor your reply.

If I undserstand, when I update my view in my instance mydb2, materialized view log are not deleted.
If after I refresh my datas in mydb3, then all used logs are deleted.

Re: replicate to 2 database using snapshots log [message #285622 is a reply to message #285597] Wed, 05 December 2007 03:03 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:

rows are deleted [in mview log] up to the oldest data not refreshed in all targets.


Regards
Michel
Previous Topic: Using Replication for Backup
Next Topic: Oracle Materialize View - High Redo Generation
Goto Forum:
  


Current Time: Thu Mar 28 15:26:43 CDT 2024