tanu sidana
asked on
How do i disable all DB links in oracle database
How do i disable all DB links in oracle database .
can you show with example . I am using SQl developer tool
can you show with example . I am using SQl developer tool
SOLUTION
![Avatar of Alex [***Alex140181***]](https://filedb.experts-exchange.com/files/public/2022/11/13/8257e912-ee3c-4a93-9df0-fe9a8a1515cf.jpeg){kind=small}
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Mark Geerlings
Yes, Geert's suggestion is a good one. That would give you a way to disable one or more database links immediately without removing them from the database. But, this does require system administrator access to the $ORACLE_HOME on the database server (and to the network/admin sub-directory there).
i always give good suggestions
and otherwise i'll comment them with this:
// drunk, fix later
and otherwise i'll comment them with this:
// drunk, fix later
>>if you remove the entries in the tnsnames.ora on the host for those db links
Unless the links were created using the EZConnect syntax.
Unless the links were created using the EZConnect syntax.