Oracle Database Link Orakulo Database Link

In distributed Oracle environments, database links can be used to define a communications path between two databases. Sa ipinamamahagi Oracle kapaligiran, ang database ng mga link ay maaaring gamitin upang tukuyin ang isang landas na komunikasyon sa pagitan ng dalawang database. A database link defines a network connection, and, optionally, a username and password, to use when Oracle accesses and establishes a database session in the remote database on behalf of the local application request. Ang isang database ng link na tumutukoy ng isang network connection,, at opsyonal, ng isang username at password, upang gamitin kapag Oracle accesses at nagtatatag ng isang database ng session sa mga remote na database sa ngalan ng lokal na aplikasyon kahilingan.

Database link enable SQL statements to be isolated from the underlying physical network topology. Database link na paganahin ang SQL pahayag na ilang mula sa pisikal na batayan ng network topology. Thus, whenever the location of a remote database changes, only the link need be updated, and not each and every SQL queries, significantly the tasks of programmer. Kaya, kapag ang lokasyon ng isang malayuang database ng mga pagbabago, lamang ang link na kailangan ma-update, at hindi ang bawat isa at bawat SQL query, makabuluhang mga gawain ng programmer.

Oracle database link is defined in a specific database, and may be used only by users of that database. Orakulo database link ay tinukoy sa isang tiyak na database, at maaaring gamitin lamang ng mga gumagamit ng database. If the same database link name was to be used from all databases in the network, the links must be defined identically with that name in each of each databases. Kung ang parehong mga database ng link pangalan ay maaaring gamitin mula sa lahat ng database sa network, ang link ay dapat na may tukoy na identically na pangalan sa bawat isa sa bawat database. For this scenario, the easier way is to be global database link. Para sa ganitong sitwasyon, ang mas madaling paraan ay ang database ng mga global na link.

Database Link Creation Database Link Creation

Login into Oracle database (with SQL*Plus, for example) as a user who has the privilege to create a database link and execute the following command: Mag-login sa Oracle database (sa SQL * Plus, halimbawa) bilang isang user na may pribilehiyo na lumikha ng isang database ng link at execute ang mga sumusunod na command:

CREATE DATABASE LINK link_name Gumawa ng DATABASE LINK link_name
CONNECT TO user_name IDENTIFIED BY password Kumonekta sa USER_NAME kinilala NG password
USING 'connection_string'; GAMIT 'connection_string';

where connection_string is an entry is tnsnames.ora (usually located in $ORACLE_HOME/network/admin), which enables the Oracle to know the network path to remote database. kung saan connection_string ay isang entry ay tnsnames.ora (karaniwan ay matatagpuan sa $ ORACLE_HOME / network / admin), na nagbibigay-kakayahan sa Oracle na malaman ang mga network ng landas sa malayuang database.

connection_string has the following structure: connection_string ay may mga sumusunod na istraktura:

(DESCRIPTION = (Description =
(ADDRESS = (ADDRESS =
(PROTOCOL = TCP) (Host = host_name/ip_address) (Port = 1521) (Protocol = TCP) (Host = host_name / ip_address) (Port = 1521)
) )
(CONNECT_DATA = (CONNECT_DATA =
(SERVER = DEDICATED) (Server dedikado =)
(SERVICE_NAME = database_name) (SERVICE_NAME = database_name)
) )
) )

Database Link Deletion Database Link deletion

To delete a database link: Upang tanggalin ang isang database na link:

DROP DATBASE LINK link_name; Drop DATBASE LINK link_name;

IMPORTANT : The page is machine translated and provided "as is" without warranty. MAHALAGA: Ang mga pahina ay makina isinalin at ibinigay "gaya ay" walang warranty. Machine translation may be difficult to understand. Machine translation ay maaaring maging mahirap na maintindihan. Please refer to Mangyaring tingnan ang original English article orihinal na Ingles na artikulo whenever possible. hangga't maaari.

Related Articles Mga Kaugnay na Akda

• View and Retrieve Oracle Database Link Details Tingnan at Kunin Oracle Database Link Mga Detalye
• Change Oracle Database User Password Baguhin ang Oracle Database User Password
• Oracle Database Import Error 3113/3114 I-import ang Oracle Database Error 3113/3114
• Create, Add or Split Oracle Database Partition Fails with ORA-14080 Error Gumawa, o Magdagdag ng Split Oracle Database Partisyon nabigo sa ORA-14080 Error
• How Drop Tablespace and Recover Oracle Database When Accidentally Delete Datafile Paano Drop Tablespace at mabawi Oracle Database Kapag sinasadyang Tanggalin Datafile
• Oracle EXP-00091 Error When Export Database Oracle EXP-00091 Error Kapag export Database
• How to Remove and Drop Datafiles from Tablespace in Oracle Database Paano Tanggalin at Drop Datafiles mula sa Tablespace sa Oracle Database
• IMP-00016 Required Character Set Conversion Not Supported Error when Import to Oracle Database Malikot na bata-00016 Kinakailangan Character Set Conversion Not Supported Error kapag-angkat sa Oracle Database
• Check Oracle Version Suriin ang Oracle Version
• Oracle JDeveloper Reviews Oracle JDeveloper review

This entry was posted on Saturday, January 14th, 2006 at 4:05 pm and is filed under Ang entry na ito ay nai-post sa Sabado, January 14th, 2006 at 4:05 pm at ito ay naisaayos sa ilalim ng Databases Databases . . You can follow any responses to this entry through the Maaari mong sundin ang anumang sagot na ang entry na ito sa pamamagitan ng RSS 2.0 RSS 2.0 feed. You can feed. Maaari ninyong leave a response mag-iwan ng tugon , or , O trackback Trackback from your own site. mula sa iyong sariling site.