Google+ Followers

Pages

Tuesday, February 17, 2015

Changing Database link password without recreating



 It is possible to change a database link password without dropping and recreating a database link.

The ALTER DATABASE LINK statement can be used and you do not need to specify the target TNS Service name either.


ALTER DATABASE LINK DB_LINK_NAME connect to USER_NAME identified by  NEW_PASSWORD;















main url: https://jhdba.wordpress.com/2015/02/13/changing-a-database-link-password/

4 comments:

  1. No matter what database platform you’re running, dbaDIRECT is your answer for 24×7 monitoring and expert skill, at a lower cost than what’s possible with internal administration. We offer each of our core remote management services for all major database platforms, including Oracle, Sybase, MySQL, SQLServer, and IBM DB2. Our team of DBAs is here ’round the clock for your database needs, capable of servicing any size organization at any time of the day. Period.
    Remote dba services support 24x7 of below mentioned applications - more… Online Training- Corporate Training- IT Support U Can Reach Us On +917386622889 - +919000444287
    http://www.21cssindia.com/support.html

    ReplyDelete
  2. Thank you for posting such a useful, impressive and informative content.

    Clone database from physical standby as target in oracle.

    ReplyDelete
  3. Database means to maintain and organize all the files in a systematic format where the data can be easily accessible when needed.
    Oracle DBA training in chennai | Oracle training in chennai | Oracle course in Chennai

    ReplyDelete