|René Nyffenegger's collection of things on the web|
René Nyffenegger on Oracle - Most wanted - Feedback
save [file] file-name [create|replace|append]
Saves the content of the SQL*Plus buffer into the file named file-name.suffix.
The suffix is .sql unless it has been specified with set suffix.
The file can be loaded again into the SQL*Plus buffer with get.
The save command won't work if the restriction level is set to at least 2:
C:>sqlplus -r 2 rene/rene SQL*Plus: Release 10.2.0.1.0 - Production on Thu Aug 17 21:10:39 2006 Copyright (c) 1982, 2005, Oracle. All rights reserved. Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production With the Partitioning, OLAP and Data Mining options RENE> save xyz SP2-0738: Restricted command "save" not available RENE>