Oracle Baz� de date Link

�n�untru a distribui Oracle mediu, baz� de date links a putea a fi folosit la define un comunic�ri patetic between doi baz� de date. UN baz� de date link defines un re�ea unire, �i, optionally, un username �i password, la spre folos c�nd Oracle accesses �i a stabili un baz� de date sesiune �n remote baz� de date on behalf de la local cerere a cere.

Baz� de date link enable SQL declara�ie la spre a fi isolated de la underlying physical re�ea topology. Thus, oric�nd art.hot. a localiza de un remote baz� de date scimbare, unic art.hot. link nevoie a fi updated, �i nu each �i fiecare SQL �ntrebare, significantly art.hot. tasks de program.

Oracle baz� de date link is defined �n�untru un special baz� de date, �i Mai a fi folosit unic by users de that baz� de date. Dac� art.hot. same baz� de date link nume was la spre a fi folosit de la tot baz� de date �n re�ea, art.hot. links musta�� a fi defined identically cu that nume �n�untru each de each baz� de date. Pentru this scenario, art.hot. easier way is la spre a fi global baz� de date link.

Baz� de date Link A crea

Login into Oracle baz� de date ( cu SQLPlus*, pentru example) as un user cine has art.hot. privilege la spre a crea un baz� de date link �i execute art.hot. a urma virgul�:

A CREA BAZ� DE DATE LINK link_name
A LEGA LA SPRE user_name IDENTIFIED BY password
FOLOSIRE ‘connection_string’;

unde connection_string is un intrare is tnsnames.ora (usually situat �n�untru $ORACLE_HOME/ re�ea/admin), care enables art.hot. Oracle la spre know art.hot. re�ea patetic la spre remote baz� de date.

connection_string has art.hot. a urma structure:

(DESCRIPTION =
(adres�=
(PROTOCOL = TCP) ( gazd� = host_name/ip_address) ( port = 1521)
)
(CONNECT_DATA =
(a servi = DEDICATED)
(SERVICE_NAME = database_name)
)
)

Baz� de date Link A �terge

La spre a �terge un baz� de date link:

DROP DATBASE LINK link_name;

import: Aceasta este o machine a traduce pagin� care is provided "as is" f�r� warranty. Machine traducere Mai a fi difficult la spre understand. A face pe plac la refer la spreorigine Englez anghinar� oric�nd posibil.

Share �i contribute sau a lua technical cin� �i ajutor laMeu Digital Via�� Forums.

Rela�ii Anghinar�

• Oracle Baz� de date Import Error 3113/3114
• Vedere �i Retrieve Oracle Baz� de date Link Details
• Scimbare Oracle Baz� de date User Password
• A verifica Oracle Traducere
• Cum Drop Tablespace �i A nota Oracle Baz� de date C�nd Accidentally A �terge Datafile
• Oracle EXP-00091 Error C�nd Export Baz� de date
• Manual �i Clar Uninstall Oracle pentru Ferestre
• A crea, A aduna sau A�chie Oracle Baz� de date Partition Fails cu ORA-14080 Error
• Oracle JDeveloper Copie
• Oracle ORA-01658 Incapabil la spre A crea INITIAL Prelungire pentru Segment �n�untru Tablespace Error

This intrare was post on S�mb�t�, Ianuarie 14th, 2006 la 405: pm �i is dosar josBaz� de date. Tu po�i a urma orice r�spuns la spre this intrare g�t art.hot.RSS 2.0 feed. Tu po�iplecare un r�spuns,sau trackback de la al t�u own site.