If you want to access a database without it being in your tnsnames.ora file, you can use a ‘URL’ at the command line:
sqlplus login/pwd@//hostname:1521/sidname
This should work with versions 9 and above. Let me know if other versions work.
Our Blog. We have some things we'd like to share.
-
Categories
-
Tags
php presentation ajax s3 gis javascript ui Louisville community Design social networking ux rails mobile System Administration Utilities linux Oracle Mission Data client java ruby
-
Archives
- January 2012
- September 2011
- August 2011
- May 2011
- April 2011
- March 2011
- February 2011
- January 2011
- December 2010
- November 2010
- October 2010
- September 2010
- May 2010
- March 2010
- February 2010
- October 2009
- September 2009
- August 2009
- February 2008
- January 2008
- April 2007
- March 2007
- December 2006
- November 2006
- October 2006
- September 2006
- August 2006
- July 2006
- June 2006
- May 2006
- April 2006
- March 2006
- February 2006
1
Uh, wrong!
That only works in 10g and the syntax is:
sqlplus login/pwd@//hostname:1521/servicename
Get on the ball bud!