Tuesday, July 1, 2008

Making SQLPLUS connection to remote database

Making SQLPLUS connection to remote database:

  1. sqlplus system/manager@test.gdbsi.com using connect string
  2. sqlplus system/manager@//hostname:portname/dbname
  3. sqlplus system/manager@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521)))(CONNECT_DATA=(SID=TEST)))
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)