The Unload utility
140
Switch Description
–o filename Log output messages to a file
–p char Escape character for external unloads (default "\")
–q
Quiet mode—no windows or messages
–r reload-file Specify name and directory of generated reload
Interactive SQL command file (default
reload.sql
)
–t table,... Unload only the listed tables
–u
Unordered data. Do not use indexes to unload data.
–v
Verbose messages
–xi
External unload, internal reload
–xx
External unload, external reload
–y
Replace the command file without confirmation
directory The directory where the unloaded data is to be
placed. Not needed for -an or -ac
In the default mode, or if -ii or -xx is used, the directory used by
dbunload
to hold the data is relative to the database server, not to the current directory
of the user. For details of how to supply a filename and path in this mode,
see "UNLOAD TABLE statement" on page 635.
If the
-x, -xi, or -xx is used, the directory is relative to the current directory
of the user.
The
reload.sql
command file is always relative to the current directory of the
user.
If no list of tables is supplied, the whole database is unloaded. If a list of
tables is supplied, only those tables are unloaded.
$ For more information about the command-line switches, see "Unload
utility options" on page 140.
$ There are special considerations for unloading databases involved in
replication. For information, see "Unloading and reloading a consolidated
database" on page 558 of the book Replication and Synchronization Guide.
Unload utility options
Connection parameters for reload database (–ac) This switch causes
the Unload utility to connect to an existing database and reload the data
directly into it. You can combine the operation of unloading a database and
reloading the results into an existing database using this option.
Description
To Next Page
Loading...