DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: is it possible to alter the db link?

  1. #1
    Join Date
    Nov 2001
    Location
    Singapore
    Posts
    182

    is it possible to alter the db link?

    i have a db link

    sql>create database link fin_warehouse connect to dw_user identified by db_warehouse using 'dwh';

    Database link created.

    Now i want to change user name i.e dw_user to dw_users1

    i can drop and recreate the link but lot of peoples are using that link, i donot want to drop .

    is it possible to alter the link
    J Gangadhar

  2. #2
    Join Date
    Nov 2000
    Location
    Birmingham, UK
    Posts
    360
    Nope - you've got to drop and re-create it

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width