Home » RDBMS Server » Server Administration » DATABASE LINK
DATABASE LINK [message #411613] Mon, 06 July 2009 01:10 Go to next message
shekhar.salunkhe
Messages: 154
Registered: January 2008
Location: Pune
Senior Member
Hi,
I am using oracle 9i.i am working on two database. one is local and second is remote database . I am using database link to access and alter remote database. My doubt is if I have to do some thing to handle commit or rollback in both database or it is handled by oracle itself. I have studied about two phase commit. Is it implemented by oracle itself or it need some additional resource or configuration.

Regards.
Re: DATABASE LINK [message #411615 is a reply to message #411613] Mon, 06 July 2009 01:33 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

My doubt is if I have to do some thing to handle commit or rollback in both database or it is handled by oracle itself

It is done by oracle itself. you just need to issue the command.
or may be i am not getting your question properly.
Re: DATABASE LINK [message #411624 is a reply to message #411615] Mon, 06 July 2009 02:09 Go to previous messageGo to next message
shekhar.salunkhe
Messages: 154
Registered: January 2008
Location: Pune
Senior Member
Hi,
Thanks for reply. Actually I am firing insert statement in both local and remote database but if I commit in session of local database in which application is running then effects are not commited on remote database. in this case I have problem to rollback if I get some exception in second statement. i am using dynamic query and forms_ddl on form issue these statement
Re: DATABASE LINK [message #411625 is a reply to message #411615] Mon, 06 July 2009 02:17 Go to previous messageGo to next message
shekhar.salunkhe
Messages: 154
Registered: January 2008
Location: Pune
Senior Member
If oracle handles two phase commit without any configuration then how working of integrating server and logging server is managed.
Re: DATABASE LINK [message #411664 is a reply to message #411625] Mon, 06 July 2009 05:05 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member


Also, You need to check

http://download.oracle.com/docs/cd/B10501_01/server.920/a96521/ds_concepts.htm#12354

Babu
Re: DATABASE LINK [message #412741 is a reply to message #411613] Sat, 11 July 2009 00:42 Go to previous messageGo to next message
shekhar.salunkhe
Messages: 154
Registered: January 2008
Location: Pune
Senior Member
Hi,
Can any one guide me regarding implementing security issues while using database link.
Re: DATABASE LINK [message #412742 is a reply to message #412741] Sat, 11 July 2009 00:51 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
There is no difference with a "normal" user.

Regards
Michel
Previous Topic: SYS user and its privileges
Next Topic: not able to resize back datafile.
Goto Forum:
  


Current Time: Sun Dec 04 08:41:40 CST 2016

Total time taken to generate the page: 0.08212 seconds