Command "archive log list" Not Working

Toad for Oracle & DevOps Toolkit
1

When I run the following with F5:

show sga
show pdbs
show parameter db_flashback_retention_target
archive log list

The result is:

Total System Global Area   17179865096 bytes
Fixed Size                     9207816 bytes
Variable Size               3355443200 bytes
Database Buffers           13522436096 bytes
Redo Buffers                 292777984 bytes
    CON_ID CON_NAME                       OPEN_MODE  RESTRICTED
---------- ------------------------------ ------------ ------------
         2 PDB$SEED                       READ ONLY  NO
         5 SOPTWITH_CAMEL                 READ WRITE NO
db_flashback_retention_target        integer  1440
unknown command "archive log" - rest of line ignored.

'archive log list' is a valid sqlplus command going way back. It does work if I "Execute via SQL*Plus".

(Toad 17.0, Instant Client 19c)

Cheers,
Russ

2

Hi Russ,

F5 isn't intended to support every SQL*Plus command.

-John

3

Well, isn't that just ducky.