OraFAQ Forum: Replication » Updatable Snapshots on a complex view, and not on a table

Home » Server Options » Replication » Updatable Snapshots on a complex view, and not on a table

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Updatable Snapshots on a complex view, and not on a table [message #75445]

Thu, 08 January 2004 05:38

Markus Otto
Messages: 1
Registered: January 2004

Junior Member

Hi,

i'm working hard on a problem:
There will be some fundamental changes in our appliation referring to the database objects (The enviroment has many updatable snapshot).

It would be fine if first the db-changes would be implemented on the master, and some days later on the snapshot-sites. The relevant tables, which will be changed, are all updatable snapshots.

So,my idea:
In order to separate these changes from the snapshot-databases i got the idea to create an updatable snapshot not on the table, but on a complex view. Unfortunately my attemps leaded to Ora-errors.

So, the docu says that views can be replicated. Can anyone give me please some hints ?

best regards
Markus

Report message to a moderator

Re: Updatable Snapshots on a complex view, and not on a table [message #75453 is a reply to message #75445]

Fri, 30 January 2004 14:03

ilver
Messages: 50
Registered: January 2004

Member

Hi,
Remember that updateable snapshots don't support some features that could be part of your complex view.
Things like aggregating and summing isn't possible.
Check the documentation for limitations.
/ilver

Report message to a moderator

Previous Topic:	Replication Vs Constraints
Next Topic:	Snaphots status='INVALID'

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Oct 31 12:43:22 CDT 2025