Monday, June 23, 2014

Run Sql Script from Linux

To run an sql script from my Linux, i used to set the connection string in tnsnames.ora and had to set the TNS_ADMIN environment variable. I have realised that we need not do this as we can directly run using:
sqlplus <username>/<password>@<host>:<port>/<sid>

No comments: