Syntax to create database link

Category : Home > Databases > Oracle

Syntax for creating db link in Oracle database:

create database link LINKNAME connect to USERNAME identified by "PASSWORD" using 'DBNAME';

Options


Start discussion or add comment to this tip

Details

Tip reference : #88 views : 6492	Added on : 03/08/06	Submited by : h8dk97

Send a message	Printer friendly output Display this member's tips (149)


<< Previous Next >>

	Most viewed tips
	Databases > Oracle > Security : How to unlock Oracle user account
	Databases > Oracle > Performance Tuning : How to enable trace in Oracle
	Databases > Oracle : Kill user session
	Databases > Oracle : Scripts to backup Oracle database on Windows NT

	All categories Databases \| Programming \| Hardware \| Operating Systems \| Networking \| Internet \| ERP / CRM \| Games & Multimedia \| Graphics & Design \| Miscellaneous \| Office Software \| TipLib FAQ