Oracle Database Link Oracle Database Link

In distributed Oracle environments, database links can be used to define a communications path between two databases. V razdeljeni Oracle okoljih, podatkovne baze povezave lahko uporabijo za opredelitev komunikacijskih poti med dvema podatkovnih baz. 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. Baze link definira omrežno povezavo, in, neobvezno, uporabniško ime in geslo, ki se uporabljajo pri Oracle dostopi in vzpostavlja bazo podatkov zasedanju v oddaljene zbirke podatkov o imenu lokalnih zahteva uporabo.

Database link enable SQL statements to be isolated from the underlying physical network topology. Database link omogočajo SQL izjave, ki bodo ločeni od osnovne fizične omrežne topologije. 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. Tako je, kadar lokacije oddaljene sprememb baze podatkov, le povezavo treba posodobiti, in ne vsak SQL poizvedb bistveno naloge programmer.

Oracle database link is defined in a specific database, and may be used only by users of that database. Oracle baze podatkov povezava je opredeljena v posebni zbirki podatkov, in se lahko uporabljajo samo uporabniki te baze podatkov. 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. Če isto povezavo podatkovne baze je bilo ime, ki se uporablja od vseh podatkovnih zbirk v omrežju, mora biti opredeljena enako povezave s tem imenom v vsaki od posameznih podatkovnih baz. For this scenario, the easier way is to be global database link. Za ta scenarij, lahek način je, da je treba globalno bazo podatkov 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: Prijava v bazo Oracle (s SQL * Plus, na primer) kot uporabnik, ki je privilegij, da se oblikuje podatkovna baza povezavo ter izvršiti sledeč zapoved:

CREATE DATABASE LINK link_name CREATE DATABASE LINK link_name
CONNECT TO user_name IDENTIFIED BY password CONNECT TO user_name identificira z geslom
USING 'connection_string'; USING '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. connection_string kjer je vpis tnsnames.ora (ponavadi se nahaja v $ ORACLE_HOME / network / admin), ki omogoča Oracle vedeti omrežja pot do oddaljene podatkovne baze.

connection_string has the following structure: connection_string ima naslednjo strukturo:

(DESCRIPTION = (OPIS =
(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) (DEDICATED SERVER =)
(SERVICE_NAME = database_name) (SERVICE_NAME database_name =)
) )
) )

Database Link Deletion Database Link brisanja

To delete a database link: Če želite zbrisati zbirko podatkov link:

DROP DATBASE LINK link_name; DROP DATBASE LINK link_name;

IMPORTANT : The page is machine translated and provided "as is" without warranty. POMEMBNO: stran je stroj prevod in če "kot je" brez garancije. Machine translation may be difficult to understand. Strojno prevajanje je lahko težko razumeti. Please refer to Prosimo, da original English article original angleški člen whenever possible. kadar je to mogoče.

Related Articles Povezani članki

• View and Retrieve Oracle Database Link Details Ogled in Retrieve Oracle Database Link Details
• Change Oracle Database User Password Spremeni Oracle Database Uporabnik Geslo
• Oracle Database Import Error 3113/3114 Oracle Database Import Error 3113/3114
• Create, Add or Split Oracle Database Partition Fails with ORA-14080 Error Ustvarjanje, Dodaj ali Split Oracle Database prekat ne zadostovati s ORA-14080 zmota
• How Drop Tablespace and Recover Oracle Database When Accidentally Delete Datafile Kako kaplja Tablespace in zopet Oracle Database Če pomotoma zbrisali Datafile
• Oracle EXP-00091 Error When Export Database Oracle EXP-00091 zmota čas Export Database
• How to Remove and Drop Datafiles from Tablespace in Oracle Database Kako umakniti ter kaplja Datafiles iz Tablespace v Oracle Database
• IMP-00016 Required Character Set Conversion Not Supported Error when Import to Oracle Database IMP-00016 Zahtevani Character Set Conversion ne zaslomba zmota čas uvoz v Oracle Database
• Check Oracle Version Preverite Oracle Version
• Oracle JDeveloper Reviews Oracle JDeveloper Reviews

This entry was posted on Saturday, January 14th, 2006 at 4:05 pm and is filed under Ta vnos je bil objavljen v soboto, januar 14th, 2006 v 4:05 in je vložena na podlagi Databases Databases . . You can follow any responses to this entry through the Vi moči slediti poljuben odgovor do danes vstop skozi RSS 2.0 RSS 2.0 feed. You can krme. Lahko leave a response dopusta odgovor , or , Ali trackback trackback from your own site. iz vaše strani.