oracle-databasesqlplusspool

oracle spool have any settings to remove default lst extension?

In oracle spool, if we not specify the spool file extension, we get "file.lst", any settings to get file?

Solution

  • No, that seems not possible. The documentation says

    If you do not specify an extension, SPOOL uses a default extension (LST or LIS on most systems). The extension is not appended to system files such as /dev/null and /dev/stderr.

    https://docs.oracle.com/en/database/oracle/oracle-database/19/sqpug/SPOOL.html#GUID-61492052-ECCB-45C8-AF94-AB9794C60BEA