Home » Server Options » Streams & AQ » Oracle Data Replication (Oracle 10g)
Oracle Data Replication [message #439062] Wed, 13 January 2010 22:34 Go to next message
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
Re: Oracle Data Replication [message #439077 is a reply to message #439062] Thu, 14 January 2010 01:43 Go to previous message
Michel Cadot
Messages: 58959
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
if Oracle Streams concept is what shall be used.

Yes (don't your OCP allow you to know it?).

Quote:
And if used, it can be used for striping data at table/tablespace level

Quote:
(not sure of the right terminology)

So explain what do you mean with "striping".

Regards
Michel
Previous Topic: Multiple Master Databases, but one replication site
Next Topic: Server Timezone changed issue in Oracle Streams Replication
Goto Forum:
  


Current Time: Wed Sep 03 02:20:36 CDT 2014

Total time taken to generate the page: 0.07720 seconds