Map User Training - V5.4.pptx
53 Pages
English

Map User Training - V5.4.pptx

-

Downloading requires you to have access to the YouScribe library
Learn all about the services we offer

Description

Premium Edition User Training Version 5.4 Developed by Ken Stewart Anderson Asquenazi
  • click with left button
  • actions menu as the relate
  • basic user tools
  • view activity
  • action menu
  • minimum requirements
  • map window
  • minimum
  • map
  • tools

Subjects

Informations

Published by
Reads 11
Language English

Exrait

Oracle Database Links Master Class Part 1
Written and presented
by Joel Goodman
July 1st 2009
Copyright © 2009, Oracle. All rights reserved.About Me
• Email: Joel.Goodman@oracle.com
• Blog: dbatrain.wordpress.com
• Application Development and Support 1976 to 1982
• Software Development and Consultancy 1983 to 1986
• IT Training Mainframe Technology 1986 to 1993
• Oracle Support 1994 to 1996
• Oracle University 1997 to Present
• OCP DBA 1997 to Present - Releases 7.3 to 11g
• Oracle 9i OCM DBA from 2002 10g from 2006
• DBA Curriculum Delivery: Basic, Advanced, DSI
• Global DBA Certification Development Team Leader
• EMEA Core Delivery Technical Team Leader
• Member DBA Curriculum Quality Review Team
• Member Oak Table Network
2 Copyright © 2009, Oracle. All rights reserved.Mini-Lesson Objectivesii-Lon jci
• Database Links Defined
•tba ink fin
• Globally Unique Object Names
•lall iqu jet me
• Database Links Description
•tba ink scritin
• Creating and Managing Database Links
•tin d Mgin tab Lin
• Global Database Naming
•lal tba mi
• Database Link Initialisation Parameters
•tba ink Iitilisti Pet
• Dictionary and Dynamic Performance Views
•ition nd ami rfnc iws
• Statistics, Wait Events and Database Links
•ttisti, ait nt Dtse is
• Common Errors Using Database Links
•m ro in tab in
• Remote Access Management
•ot es nant
• Location Transparency
•tio annc
3 Copyright © 2009, Oracle. All rights reserved.Database Links Definedab Lin efi
A Database Link is:
• A Pointer from one DB to another
• Stored in the Data Dictionary
• Is a “Uni-Directional” Resource Definition
• DB Links between different versions of
Oracle must be supported based on the
client-server Interoperability matrix. See
note 207303.1
• Is Used by Streams,Replication,DB Cloning
and Data Guard
4 Copyright © 2009, Oracle. All rights reserved.Database Links Categoriesba ink teis
Database Links have three main Dimensions:ate Li ha tre in insi:
• Ownership
•eri
– Privaterivt
– Publicubli
– Global lol
• Security Context
•rit ntt
– Fixed Userixe r
– Connected Userontd U
– Current Userurt se
• Sharing
•in
– Sharedha
– Non-sharedon-ed
5 Copyright © 2009, Oracle. All rights reserved.Database Link Ownershipba in neip
• Private
•iate
• Public
•lic
• Global
•lal
• They may be used in combination at times
• m e u in inti at tis
6 Copyright © 2009, Oracle. All rights reserved.Creating Private Database Linksreig Pite ba in
• Create a private link that will use the connect
•te iate li that ill us t cot
string ‘SALESDW’:tig ‘SD:
CREATE DATABASE LINK SALESDW.MYCO.COM
CONNECT TO SH IDENTIFIED BY SH USING
‘SALESDW_MYCO’;
• To use the Link:
SELECT * FROM
SH.SALES@SALESDW.MYCO.COM;
7 Copyright © 2009, Oracle. All rights reserved.Private Database Link Usage
Pie Da ink ge
• Private Database Links are created in one’s own
•ite tas iks reat i o’ wn
schemama
• Are visible in USER_DB_LINKS view
• isil i UB_S vi
• “OWNER” column in DBA_DB_LINKS and
•ER lm i BALINnd
ALL_DB_LINKS views will have usernameDBKSis will ve am
• May be used only by the link owner
• be onl th li ow
• May be used with a Public Link of the same name
• be wit ubli ink f t s am
for maintenance reasons
f aitnc on
• The “USING” clause and a corresponding
• “US cl an rredin
TNSNAMES.ORA entry are requiredAMRAt ar uir
• Requires the “CREATE DATABASE LINK” system
•ire t “CE ASNK tem
privilegeiileg
8 Copyright © 2009, Oracle. All rights reserved.Creating Public Database Links
Crig lic ba ink
CREATE PUBLIC DATABASE LINK SALESDW.MYCO.COM
USING ‘SALESDW_MYCO’;
• To use the Link:
SELECT * FROM
SH.SALES@SALESDW.MYCO.COM;
9 Copyright © 2009, Oracle. All rights reserved.Public Database Link Usage
Plic Das ink ge
• Public Database Links are on the public
•lic tas is a th lic
“schema”em
• Are visible in ALL_DB_LINKS view
• isil i A_L vi
• “OWNER” column in DBA_DB_LINKS and
•ER lm i BALINnd
ALL_DB_LINKS views will be “PUBLIC”DBKSis will “PC”
• May be used by any user
• be by us
• The “USING” clause and a corresponding
• “US cl an rredin
TNSNAMES.ORA entry are optional but often used AMRAt ar tionl t oft se
• May have same name as a private link to separate
• ha me e a ivat lik t arat
the Network details fro the security details easing
t et detil fro t cuit etail sin
administration inisttin
• Requires the “CREATE PUBLIC DATABASE LINK”
•ire t “CE C BAIN
system privilegetm iileg
10 Copyright © 2009, Oracle. All rights reserved.