One of my QA Engineer in my office complained about an oracle Error while running the database script when he was doing his daily QA deployment.
Enter user-name: Test1/test1@qadev1
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management,
OLAP
and Real Application Testing options
SQL> C:\db\QA1/989898989\QAFIX_989822_1.sql
SP2-0024: Nothing to change.
I checked it and found that my QA guy has not inlcuded '@' before running the query.
Correct one is:
SQL> @C:\db\QA1/989898989\QAFIX_989822_1.sql
This solved his issue.
