Friday 1 June 2012

sqlplus without tnsnames


I sometimes find it useful to connect without tnsnames. Occasionally this can be a must when using an instant client.

For example;
sqlplus developer@'(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(COMMUNITY=TCP.world)(PROTOCOL=TCP)(Host=DEVDB)(Port=1521)))(CONNECT_DATA=(SID=DEV)))'

NB. Note the use of the single apostrophe's.

No comments:

Post a Comment