OraFAQ Forum: Streams & AQ » Oracle Data Replication

Home » Server Options » Streams & AQ » Oracle Data Replication (Oracle 10g)

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

Oracle Data Replication [message #439062]

Wed, 13 January 2010 22:34

rupaliss
Messages: 6
Registered: July 2007
Location: Mumbai

Junior Member

Hello Team,

I am SAP Basis Consultant with OCP 10g certified.

We have a new request where we have to perform Data striping (not sure of the right terminology) on certain important tables to improve the performance.

If commit is triggered on any of the tables in one database, committed data should be applied onto another table or database.

I would like to know, if Oracle Streams concept is what shall be used. And if used, it can be used for striping data at table/tablespace level instead of entire Database level (only few important tables).

Or

Materialized view - how much helpful is this ??

Kindly request you'll to help me with any documents if available.

Regards
Rupali S

Report message to a moderator