![]() ![]() For local links, the special entry of 'local' is used. Most commonly, a database link is used to connect to a user in a remote database, where the USING clause points to an entry in the database servers "tnsnames.ora" file. Public database links are visible to all users in the database and are as such a potential security nightmare. Private database links are only visible to the owner of the link. Private database link to a user in the local database. Private database link to a user in a remote database, with full connection string. Private database link to a user in a remote database. There are a variety of syntax variations in the documentation, but the ones you will most commonly use are as follows. When accessing a remote object over a database link, the local database is acting as an Oracle client. Typically, the remote database will be another Oracle database, but it can be any ODBC compliant database (see Heterogeneous Services - Generic Connectivity). ![]() Heterogeneous Services (Generic Connectivity) : Oracle to Non-Oracle Database Links Using ODBCĪ database link allows you to reference objects in a remote database.Proxy User Authentication and Connect Through in Oracle Databases.This article discusses some of the general points about database links, as well as highlighting the common mistakes associated with their use. I am not a big fan of database links, mostly because of the way people abuse them. Home » Articles » Here Managing Database Links
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |