Oracle Server Manager User's Guide

SPOOL

Purpose

Enable or disable spooling of output to a specified file.

Prerequisites

None.

Syntax

SPOOL command ::=

where:

filename Any valid name for a spool file. If not specified, the file type or file extension is LOG. If a file by the specified name exists, an error is generated.
OFF Closes the previously opened spool file.

SQL Worksheet Behavior

In a SQL Worksheet, if you issue the SPOOL command without specifying a filename, Server Manager brings up the standard file selection dialog box for your system.

Usage Notes

If you do not specify a file, Server Manager prompts you for a filename.

Additional Information: The default filename is operating system specific. Refer to your operating system-specific Oracle documentation for the default filename on your operating system. To see whether you are currently spooling, enter SHOW SPOOL.

Example

To create a file named NOV2.LOG, enter:

SPOOL NOV2

filename	Any valid name for a spool file. If not specified, the file type or file extension is LOG. If a file by the specified name exists, an error is generated.
OFF	Closes the previously opened spool file.