On unix systems, both double quotes " and single quotes ' will do:Īn environment variable can be used ( both quotes ):Įxport DB="(DESCRIPTION\=(ADDRESS_LIST\=(ADDRESS\=(PROTOCOL\=TCP)(HOST\=)(PORT\=1527)))(CONNECT_DATA\=(SERVICE_NAME\=TEST)))"Įxp spaces are allowed in the string in either case this will not work because of the space after the = sign: So kindly explain me what is global_name and where it will be useful, secondly why error is comming when I am using global_name parameter ? Sqlplus = (ADDRESS = (COMMUNITY = TCP) (PROTOCOL = TCP) (Host = mumsa000200)(Port = 1521))(CONNECT_DATA =(SID = infod)(GLOBAL_NAME = infod))) "-V" displays the SQL*Plus version bannerĬ:\orahome1\ora92\bin>sqlplus =(SID = TESTDB))" "-H" displays the SQL*Plus version banner and usage syntax JServer Release 9.2.0.6.0 - from Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit ProductionĬ:\orahome1\ora92\bin>sqlplus =(SID = TESTDB)) With the Partitioning, OLAP and Oracle Data Mining options Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production Gave it a try.it isnt working but I may be missing something very basic Tom, I know DBLINKs can be created like that but never tried from sqlplus (until I read this)
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |