Solved

oracle 10gr2 tables syncing

Posted on 2013-05-11
5
395 Views
Last Modified: 2013-05-17
dear sir,

can some one assist, we are using rhel 5.8 64 bits with oracle 10gr2

we want send tables data daily basis realtime or by schedule to another pc machine which has similar to the above env, but different hostname,ip but oracle instance db name is same, majorly they are inside 2 oracle schemas say operation schema and gl schemas consist of tables.


any technical term use for it advise

kind regards
tmsa
0
Comment
Question by:tmsa12
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39158401
What is the purpose for the synchronization?

I assume you want one-way.  If two way I suggest Oracle Streams.

For one-way I would look at dataguard and a standby database.  There are limitations on the availability of the receiving database.

There is also export/import.  Possibly log miner.

Until we know the requirements it will be hard to provide the best advice.
0
 

Author Comment

by:tmsa12
ID: 39159227
dear sir

thank your reference response

oracle database replication any facilty or tools inside oracle or outside available.

i understand the dataguard stanby

any possible feature, i heard name of table transport feature in oracle

but in all honesty no idea how where to work around get helpline

kind regards
tmsa
0
 

Author Comment

by:tmsa12
ID: 39159229
dear support

thank you

can we find some help line of tablespace transport or table transport from 1 machine to another same env, same rhel 5.8, oracle 10gr2 also same.

any possible option

kind regard
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 39161160
>>can we find some help line of tablespace transport

I'll defer to the online docs for information on transportable tablespaces:
http://docs.oracle.com/cd/B19306_01/server.102/b14231/tspaces.htm#i1007169

>>oracle database replication any facilty or tools inside oracle or outside available.

Oracle Streams Replication is what I was suggesting.  There is also an older Replication method available but I prefer Streams.
0
 
LVL 29

Accepted Solution

by:
MikeOM_DBA earned 500 total points
ID: 39169704
You could try Clover  ETL community edition (free).
:p
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Use of Exception to end a Loop 3 54
Read XML values 8 56
join a table with user_tab_columns in oracle 3 68
Oracle cursor lifecycle inside procedure. 2 25
Why doesn't the Oracle optimizer use my index? Querying too much data Most Oracle developers know that an index is useful when you can use it to restrict your result set to a small number of the total rows in a table. So, the obvious side…
Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
This video explains at a high level about the four available data types in Oracle and how dates can be manipulated by the user to get data into and out of the database.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.

756 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question