Re: SQL Command list history on Linux

From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Fri, 5 Jan 2018 03:21:27 +0300
Message-ID: <CAOVevU7taosYfKUfssWTc-n=d_scUXZ4AAyShX4_A9ZH-EpgWA_at_mail.gmail.com>



And I've just found another bug: If I save SQLcl settings with "store set sqlplus_settings.sql replace" and execute _at_sqlplus_settings.sql to restore them, SQLcl returns a couple of errors:

SQL>store set sqlplus_settings.sql replace Wrote file S:\sqlplus_settings.sql

SQL>_at_sqlplus_settings.sql
Autotrace Disabled
Usage: SET DESCRIBE [DEPTH {1|n|ALL}] [LINENUM {ON|OFF}] [INDENT {ON|OFF}] SP2-0158: unknown SET option beginning "setlongchu..."

On Fri, Jan 5, 2018 at 3:18 AM, Sayan Malakshinov <xt.and.r_at_gmail.com> wrote:

> Jeff,
>
> Ah, it seems I found a bug: sqlcl can't find files from virtual drives
> mounted with subst command.
> My S: drive was created with "subst S: n:\s" command and sqlcl
> auto-completion can't find files from S:\, though it can execute them.
> But if I change directory to N:\s (original location), it works fine.
>
>
> On Fri, Jan 5, 2018 at 3:09 AM, Jeff Smith <jeff.d.smith_at_oracle.com>
> wrote:
>
>> In my windows My Documents folder
>>
>>
>>
>> After starting sqlcl, I used the CD command to nav to that directory, so
>> that’s where SQLcl is looking.
>>
>>
>>
>> Jeff
>>
>>
>>
>>
>>
>> *From:* Sayan Malakshinov [mailto:xt.and.r_at_gmail.com]
>> *Sent:* Thursday, January 04, 2018 7:05 PM
>> *To:* Jeff Smith <jeff.d.smith_at_oracle.com>
>> *Cc:* gdherri_at_gmail.com; neil_chandler_at_hotmail.com; ORACLE-L <
>> oracle-l_at_freelists.org>; Mladen Gogala <gogala.mladen_at_gmail.com>
>> *Subject:* Re: SQL Command list history on Linux
>>
>>
>>
>> Jeff,
>>
>>
>>
>> I haven't understood, where are your lo* files located?
>>
>>
>>
>
>
>
> --
> Best regards,
> Sayan Malakshinov
> Oracle performance tuning engineer
> Oracle ACE Associate
> http://orasql.org
>

-- 
Best regards,
Sayan Malakshinov
Oracle performance tuning engineer
Oracle ACE Associate
http://orasql.org

--
http://www.freelists.org/webpage/oracle-l
Received on Fri Jan 05 2018 - 01:21:27 CET

Original text of this message