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/

20 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

  4. Canon Printer Support

    Canon is one of the leading brand names in the world of electronics and computers. Hewlett Packard commonly known as Canon, it is the American multinational IT company which provides a wide range of electronic products and computer related equipments across the globe ranging from laptops, desktops, notebooks, printers, and many others to fulfill the requirements of small, medium and large-sized organizations. Due to its amazing features and excellent customer service, it is one of the most demanded brands around the world. Apart from this, Canon products are well known for their excellent performance, super functionality, accessibility, and lots of other reasons. Get best suggestions regarding Canon Printers from the support executives by dialing the
    Canon Printer Customer Service Number
    .

    Canon Printer Support Number

    ReplyDelete
  5. When you talk about printer there are lot many brands comes in your mind but HP is the one brand that actually stood out in the market. With the

    help of HP Printer Support Phone Number which is available by 24*7 you can get best solution for your printers. Our main motive is to create a long

    chain satisfied customers and provide you the best possible solution through the toll-free HP Printer Tech Support Phone Number +1 (855)-924-8222.
    HP Printer Technical Support Number

    ReplyDelete
  6. Quicken is one amongst the most famous personal finance software across the world. This software is rather old and still enjoys a top position. Launched in the year 1983, Quicken has undergone a tremendous change by now. It’s easy to navigate, allows you to manage your budget and investment details, comes with inbuilt debt reduction tools, and will remind you when your bills are due. Are you considering getting Quicken?Dial +1-855-686-6166 for Quicken support, and they will help you set it up. The Quicken Support is 24 hours available to fix your problems regarding quicken, Call at our toll free quicken support number +1-855-686-6166.

    ReplyDelete
  7. Lexmark is one of the leading brands in the world of technology of printers. But if you are facing difficulty in using Lexmark printers , we are the solution. We provide the best technical solution for Lexmark printers. We have such a skilled technician for Lexmark printer, so that they are able to troubleshoot any issue regarding your Lexmark printer. Reach our Lexmark printer customer support team for any assistance.

    ReplyDelete
  8. Quicken is a online accounting tool developed by Quicken Inc. Quicken is useful in maintaining financial records of the employees in low and mid-level companies. Sometimes users encounter certain technical issues in the software. In that case, feel free to call on our Quicken Toll-free Number to get instant help from our team of professional experts.

    ReplyDelete
  9. Epson printers is the growing brand all around the world. When we are planning to buy printers, Epson is one among the names which comes to our mind. Epson printers are known for their speed, printing quality and other outstanding features. Dial our Epson printer toll-free number for getting round the clock support for your Epson printer problems.

    ReplyDelete
  10. QuickBooks is one of the most desirable after business accounting software that will helps laborsaving on your business finances. QuickBooks allows you to effortlessly organize your hard earned money flow, track bills and invoices, pay vendors and employees, along with calculate tax for year-end reports. If an user is experiencing difficulty while working on QuickBooks like installing or running, contact us and get your issue resolved instantly. We provide online assistance for QuickBooks Support Phone Number – +1-855-686-6166.

    ReplyDelete
  11. This comment has been removed by the author.

    ReplyDelete
  12. QuickBooks Support Phone Number
    +1-888-422-3444, to connect with responsive Quickbooks Customer Service. Here you can also request a call back form QuickBooks Help division. First full-fledged Quickbooks Support provider in USA. Flexible team to help small and mid-sized business, to manage their QB Online, Payroll, Mac Desktop and Online accounting.
    Our Services
    (i)QuickBooks Payroll
    Give us a call at QuickBooks Payroll Support Phone Number 888-422-3444 to experience our world class QuickBooks tech support at the most affordable market price for every issue in QuickBooks Payroll.
    (ii)QuickBooks Enterprise Support
    Call QuickBooks enterprise support phone number +1888-422-3444. We provide best QuickBooks technical support for QuickBooks enterprise customer.
    (iii)QuickBooks POS Support
    If you wish to get a better idea and/or are interested in availing this service, get in touch with the company through QuickBooks POS Support Phone Number +1-888-422-3444.









    ReplyDelete
  13. Dell is the most popular brand in the world of printers. Billions of people are using Dell printers every year. Over a period of time, using Dell printers may cause certain technical issues. Dial our Dell printer toll-free number for any assistance regarding Dell. Our technicians will be available 24/7 to provide support.

    ReplyDelete
  14. This comment has been removed by the author.

    ReplyDelete
  15. HP printers provide outstanding printing options to its users. Moreover, HP also provides a vast variety of printers. HP has also made sure that the costing of the products that they bring to the market is reasonable and does not burn a hole in the pockets of people. HP also takes good care of their costumer’s post-sale. Printers being machines and which runs using software, it is highly common to come across minor glitches. HP makes sure they provide their users with the most efficient customer support service.HP Printer Support Phone Number is a service which is available 24×7. They provide their customers with well-experienced professionals who gave the ideal knowledge of getting around any kind of trouble that you might have to face while using an HP Printer.

    ReplyDelete
  16. It's really a great and helpful piece of info. I'm glad that you just shared this useful information with us. Please keep us up to date like this. Thank you for sharing.Here is the right place to Submit Guest Post Big Data.

    ReplyDelete