oracle grant create database link example

1. View DblinkSELECT owner,object_name from dba_objects WHERE object_type= ' DATABASE LINK ';OrSELECT * from Dba_db_links; 2. Create Dblink Prerequisites:The user who created the Dblink has the corresponding database permissions. Create public or

Oracle Create, delete database LINKCreate Dblink: Create database link [name] connect to [username] identified by [password] using ' (DESCRIPTION = (address_ LIST = (address = (PROTOCOL = TCP) (HOST = [IP]) (port

Create an Oracle database Create an Oracle database (taking Oracle10g as an example) There are two ways to create a

server where the cube is created. 2. The tnsnames configuration name of the tnsping remote database. 3. Execute the following command after logging on to sqlplus: SQL> create database link dblinktest connect to user identified by passwd using 'ceshi ';Where: Dblinktest is the name of

Two methods for creating Database Link in Oracle are described in detail. Create A dblink named dblink_name, which is connected from database A to database B. Database B has the IP addr

)(Sid_name = MSSQL)(Program = tg4msql)))****************************** 4. Configure tnsnames. ora in the Network \ ADMIN directory of the Oracle main directory. In my example:******************************MSSQL =(Description =(Address = (Protocol = TCP) (host = 192.168.1.180) (Port = 1521 ))(CONNECT_DATA = (SID = MSSQL ))(HS = MSSQL))****************************** 5. Restart listener. 6. Use sqlplus to

Database link details By creating database links between databases, you can easily perform DML operations on the data of a user in a remote database, but cannot perform DDL operations, Two Methods of database link: Public

Defining a public Database link:exampleThe following statement defines a shared public database link named remote this refers to the database specified by the SE Rvice Name Remote:CREATE public DATABASE LINK remote USING ' remote

If the database connection is not established in the local Tnsnames.ora, then 1 is used, otherwise 21:create Database Link Geelyin96Connect to Geelyin identified by GeelyinpasswordUsing ' (DESCRIPTION =(Address_list =(ADDRESS = (PROTOCOL = TCP) (HOST = 10.86.1.96) (PORT = 1521)))(Connect_data =(service_name = appdb)))‘

. Net to access the Oracle database link: ORA-02041: client database did not begin a transaction problem. . Net to access the Oracle database link: ORA-02041: client

Delete database link: drop database link linkname;Create database link:Create database link linknameConnect to usernameIdentified by passwor

oracle.manageddataaccess dependency package in the Winrun2.web and automatically generate the Oracle configuration information in config)Iii. Creating an Oracle database schema1, first to ensure that the local client can link to the Oracle DB Server, with DBA authority acco

In ORACLE, remote data access, such as query and update, can be achieved through DatabaseLink. The database connection needs to be run on both databases that have created DatabaseLink. In ORACLE, remote data access, such as query and update, can be achieved through Database Link