import(1LOCAL) MISC. REFERENCE MANUAL PAGES import(1LOCAL)
NAME
import - retrieves ORACLE data from export files
SYNOPSIS
imp username/password [keyword=value]
DESCRIPTION
The import utility, described in the ORACLE Database
Administrator's Guide, is used to retrieve ORACLE database
data from export format files and move it into an ORACLE
database.
OPTIONS
buffer
Size of the data buffer.
compress
Imports into one extent. Default is "yes".
constraints
Exports possible table constraints. Default is "no".
file
Name of the output file, (e.g., expdat.dmp).
full
Exports the entire file. Default is "no".
grants
Exports grants. Default is "no".
inctype
Incremental export type.
owner
List of owner usernames.
parfile
Parameter filename.
record
Tracks any incremental exports. Default is "yes".
recordlength
Length of the I/O records.
rows
Exports the data rows. Default is "yes".
Sun Release 4.1 Last change: 23 March 1989 1
import(1LOCAL) MISC. REFERENCE MANUAL PAGES import(1LOCAL)
tables
List of table names.
userid
Your username and password.
FILES
export files, import files
SEE ALSO
export; 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