FAST command nulls SQLPATH
(Doc ID 2730593.1)
Last updated on MARCH 02, 2022
Applies to:SQL*Plus - Version 220.127.116.11 and later
Information in this document applies to any platform.
Since 12.2 version, there is a SQLPLUS key "-fast", that should simply add several settings:
statementcache is 20
However, if -fast option is being used, the $SQLPATH variable is nulled out
1. Create a sql file test.sql with the content
select 1 from dual;
2. Save it in a location on the server, i.e. c:\temp
3. set SQLPATH=c:\temp
4. Connect with SQLPLUS
sqlplus sys/welcome1 as sysdba
5. Run the script
6. Disconnect from SQLPLUS
7. Connect again using fast command
sqlplus -fast "/as sysdba"
8. Run the script
SP2-0310: unable to open file "test.sql"
SQLPATH has been nulled
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document