Oracle data Replication [message #287652] |
Thu, 13 December 2007 01:14 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
deepak samal
Messages: 29 Registered: February 2005
|
Junior Member |
|
|
Hi ,
I am working in Oracle 10g. I am new to DBA.
Requirment: I have a database in onsite ( some other place). i am connecting to that DB. Here the data retrieval is very very slow. so i want to replicate the same DB to my local. The db size is big.so i can not ask them to export the db and sent it to me. i want to replicate the same db here locally.
If also i dont have a system/sys password then also how can i perform this task.
thanks
deepak
|
|
|
|
|
|
|
|
Re: Oracle data Replication [message #287666 is a reply to message #287662] |
Thu, 13 December 2007 01:30 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
I agree with you Arju.
It seems to me OP only wants to faster query the same database/data.
So duplication seems a better way than replication.
Of course, it depends on the ratio "needed data"/"whole database".
Regards
Michel
[Updated on: Thu, 13 December 2007 01:30] Report message to a moderator
|
|
|
Re: Oracle data Replication [message #287690 is a reply to message #287652] |
Thu, 13 December 2007 03:25 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
deepak samal
Messages: 29 Registered: February 2005
|
Junior Member |
|
|
Yes, I think i made my requirment complicated. Actually i want a duplicate schema rather than the whole databse.
Actually the server is in a different country itself. so i cant take a backup of the database locally ( also i dont have a system password). What i want is , to which schema i am connecting thru client , i want that schema in my local server.
thanks
deepak
|
|
|
|
Re: Oracle data Replication [message #287700 is a reply to message #287690] |
Thu, 13 December 2007 03:43 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
![](http://www.orafaq.com/forum/images/custom_avatars/102589.gif) |
Michel Cadot
Messages: 68675 Registered: March 2007 Location: Nanterre, France, http://...
|
Senior Member Account Moderator |
|
|
Once again, investigate if network is not your problem, if you want a up to date database or only one refreshed from time to time and which frequency.
In addition, investigate if your query are appropriate ones that is don't return thousand and thousand rows.
Regards
Michel
|
|
|