export(1LOCAL) MISC. REFERENCE MANUAL PAGES export(1LOCAL)
NAME
export - stores files containing database data
SYNOPSIS
exp [username/password] [keyword=value ...]
DESCRIPTION
The export utility is used to store ORACLE database data in
export format files for later retrieval into an ORACLE data-
base via the import utility.
OPTIONS
buffer
Size of the data buffer.
compress
Imports into one extent. Default is "Y" (yes).
constraints
Exports possible table constraints. Default is "N" (no).
file
Name of the output file; e.g., expdat.dmp).
full
Exports the entire file. Default is "N" (no).
grants
Exports grants. Default is "N" (no).
inctype
Incremental export type.
owner
List of owner usernames.
parfile
Parameter filename.
record
Tracks any incremental exports. Default is "Y" (yes).
recordlength
Length of the I/O records.
rows
Exports the data rows. Default is "Y" (yes).
tables
Sun Release 4.1 Last change: 23 March 1989 1
export(1LOCAL) MISC. REFERENCE MANUAL PAGES export(1LOCAL)
List of table names.
userid
Your username and password; e.g., scott/tiger.
SEE ALSO
import; ORACLE Installation and User's Guide for your
operating system; ORACLE Database Administrator's Guide;
ORACLE Utilities User's Guide
Sun Release 4.1 Last change: 23 March 1989 2