Databases Reference
In-Depth Information
Export terminated successfully without warnings.
E:\TEMP>
contains the definitions of
the two tables and their contents, along with any indexes, constraints, and per-
missions defined on the tables.
The operating system file
E:\temp\exp_oe.dmp
As of Oracle 10
, the command-line utility inter-
face to Oracle Data Pump, replace most of the functionality of
g
, the new utilities
EXPDB
and
IMPDB
EXP
and
IMP
in
Oracle9
and earlier and provide features such as import and export directly between
instances. The original Export and Import utilities, however, should still be used in an
Oracle 10
i
database when importing backups from a previous release of Oracle, or
you will need to export data to import into a previous release of Oracle.
g
The Import (IMP) Utility
The
reads a binary dump file produced by the Export utility
and restores the tables and any associated indexes, constraints, and permissions
saved in the dump file. The format of the
Import utility (IMP)
Import utility (IMP)
An Oracle utility that takes as input a
binary dump file created by the Export
utility and restores one or more database
tables, along with any associated
indexes, permissions, and constraints.
IMP
command is as follows:
IMP
username/password
KEYWORD=(
value1
,
value2
, ...)
command is executed without specifying any parameters, Import
can prompt the user for the parameters in an interactive mode. The username
and password belong to the user who owns the objects to be imported. The
If the
IMP
TABLES
keyword lists the tables that are to be imported from the dump file,
which defaults to a name of
EXPDAT.DMP
. Running
IMP -HELP
lists all of the
Import options. The most common keywords are listed below.
Keyword
Description
FILE
Dump file to restore from; defaults to EXPDAT.DMP
TABLES
List of table names to restore
ROWS
Import rows of the table; defaults to Y
INDEXES
Import indexes; defaults to Y
CONSTRAINTS
Import table constraints; defaults to Y
GRANTS
Import privileges granted on tables; defaults to Y
SHOW
Show just the file contents and do not perform the restore;
defaults to N
Later in the week, Gary, the database developer, inadvertently drops the
ORDER_ ITEMS
table that he was using to test his custom widgets application. He
