|René Nyffenegger's collection of things on the web|
René Nyffenegger on Oracle - Most wanted - Feedback
store set some_file
With this command, it's possible to create a file that contains all settings (such as feedback or pagesize).
The created file will have an .sql suffix (unless explicitely specified otherwise) which makes it possible to source the file for 'reuse'.
See also login.sql.
The store 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> store foo SP2-0738: Restricted command "store" not available RENE>