Cov txheej txheem:

Dab tsi yog kev siv Dblink hauv Oracle?
Dab tsi yog kev siv Dblink hauv Oracle?

Video: Dab tsi yog kev siv Dblink hauv Oracle?

Video: Dab tsi yog kev siv Dblink hauv Oracle?
Video: Leng Yang - Yog Vim Dab Tsi (Official Full Song | Nkauj Tawm Tshiab) 2020/05/24 2024, Kaum ib hlis
Anonim

A database link yog ib qho khoom siv schema hauv ib lub database uas tso cai rau koj nkag mus rau cov khoom ntawm lwm lub database. Lwm database yuav tsum tsis yog ib tug Oracle Database system. Txawm li cas los xij, txhawm rau nkag mus tsis tau Oracle systems koj yuav tsum siv Oracle Heterogeneous Services.

Tom qab ntawd, ib tug kuj yuav nug, dab tsi yog qhov txuas database hauv Oracle nrog piv txwv?

A database link tso cai rau tus neeg siv lossis qhov program nkag mus database cov khoom xws li rooj thiab kev pom los ntawm lwm tus database . SELECT * NTAWM [email tiv thaiv]_link; Thaum nkag mus rau ib lub rooj tej thaj chaw deb los yog saib dhau lub database link , cov Oracle database yog ua raws li ib tug Oracle tus neeg siv khoom.

Kuj Paub, dab tsi yog lub ntsiab lus hauv Oracle? Kev piav qhia. A lub ntsiab lus yog lwm lub npe rau cov khoom xws li rooj, views, sequences, khaws cia cov txheej txheem, thiab lwm yam khoom siv database. Koj feem ntau siv cov ntsiab lus thaum koj tso cai nkag mus rau ib qho khoom los ntawm lwm lub schema thiab koj tsis xav kom cov neeg siv yuav tsum txhawj xeeb txog kev paub txog qhov twg schema yog tus tswv ntawm cov khoom.

Kuj paub, ua li cas koj tsim ib qhov txuas database?

Tsim ib pej xeem database link npe, oralink, mus rau Oracle database npe, xe, 127.0. 0.1 ntawm chaw nres nkoj 1521. Txuas mus rau Oracle database nrog username, edb, thiab password, password. Tsim PUBLIC DATABASE LINK oralink Txuas RAU edb IDENTIFIED BY 'password' SIV '//127.0.

Kuv yuav nrhiav tau qhov txuas DB hauv Oracle li cas?

2 Teb

  1. DBA_DB_LINKS - Txhua qhov txuas DB tau teev tseg hauv cov ntaub ntawv.
  2. ALL_DB_LINKS - Txhua qhov txuas DB txuas rau tus neeg siv tam sim no tau nkag mus.
  3. USER_DB_LINKS - Txhua qhov txuas DB uas muaj los ntawm cov neeg siv tam sim no.

Pom zoo: