Accessing a remote database [message #439383] |
Sat, 16 January 2010 02:19 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
charuamit
Messages: 121 Registered: January 2009
|
Senior Member |
|
|
hi friends
i have a remote database.....i want to access some of the tables from that database....actually i want to create a schema with those tables....with auto update facility(means whenever any table in the remote database is updated then automatically in my schema it should be updated)
its very urgent..plz provide my the step by step process
thanks and regards.
|
|
|
|
Re: Accessing a remote database [message #439387 is a reply to message #439384] |
Sat, 16 January 2010 02:43 ![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) |
charuamit
Messages: 121 Registered: January 2009
|
Senior Member |
|
|
I could not open that page
My question is how to create a database link to access some of the tables of a remote database (via synonyms)
i wan to create a schema with only some tables of the remote database not all
thanks and regards
charu
|
|
|
Re: Accessing a remote database [message #439391 is a reply to message #439387] |
Sat, 16 January 2010 02:55 ![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/72104.gif) |
Littlefoot
Messages: 21809 Registered: June 2005 Location: Croatia, Europe
|
Senior Member Account Moderator |
|
|
It seems that the documentation server is down; will be up, hopefully soon so - check it now and then. (Also, for the future reference, Oracle documentation can be found at http://tahiti.oracle.com. Bookmark it!).
As of your question: Quote:whenever any table in the remote database is updated then automatically in my schema it should be updated
Perhaps you should also check a materialized view (or an older "snapshot" term, depending on your database version which you didn't mention, I think). Materialized views can be created in a way that when the "source" table changes (i.e. records are inserted, updated, deleted), materialized view on your side reflects those changes as well. You can do that instantly (by refreshing the materialized view on commit (when changes in the source table are committed)) or periodically (similar to a "scheduled" job), on demand ("refresh it RIGHT NOW!") or - never.
[Updated on: Sat, 16 January 2010 02:57] Report message to a moderator
|
|
|
Re: Accessing a remote database [message #439392 is a reply to message #439391] |
Sat, 16 January 2010 03:03 ![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) |
charuamit
Messages: 121 Registered: January 2009
|
Senior Member |
|
|
thanks
okee tell me one thing...can i create a schema with tables like
create table A as select * from ..
bt i wan auto update facility for all the tables...
can i write a trigger for that ??
|
|
|
|
Re: Accessing a remote database [message #439397 is a reply to message #439391] |
Sat, 16 January 2010 03:27 ![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) |
charuamit
Messages: 121 Registered: January 2009
|
Senior Member |
|
|
yaah i know
actually see...we already have a schema with database link to a remote database...
now for some reasons i have to give only 6 tables of that schema to a user.....and that user needs to work on the updated copy of those tables everyday.......
he don wan the full schema as there abt 50 tabels in it...
i m not somehow able to create a database link...and the person who did it before z on leave...so i have to do it...and i tried so many things bt it didnt work
can you please suggest me what to do in the easiest manner
thanks and regards
charu
|
|
|
|
|
|