Kbase 13994: ORACLE Import/Export Utilities (Dump and Load of ORACLE DBs)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
ORACLE Import/Export Utilities (Dump and Load of ORACLE DBs)
The Export and Import are two of ORACLEs utilities to assist in backup and
re-creation of an ORACLE table, database or a specific users database
The Export utility has three modes; Full, User and Table mode. In the full
mode the entire data dictionary is read and the DDL necessary to create
the ORACLE database can be directed to a dump file. In the User mode only the
specific users objects are are exported and in the Table mode only the
interactively or from a parameter file. In the interactive mode you can
execute all the options from one line or after issueing the "exp" command
hit a return to be prompted for the information. For help or details on
Utilities Guide or you may see the optional parameters displayed to your
Prior to issuing this command make sure your ORACLE_HOME and ORACLE_SID
enviroment variables are set and the ORACLE instance is up by issueing
$ exp system/manager full=Y file=full_database.dmp grants=y indexes=y
The import utility reterives the ORACLE database or table data found in the
NOTE: For futher assitance on either of the aforementioned ORACLE utilities
ORACLE EXPORT/IMPORT
====================
The Export and Import are two of ORACLEs utilities to assist in
backup and re-creation of an ORACLE table, database or a specific
users database objects.
EXPORT UTLITY
-------------
The Export utility has three modes; Full, User and Table mode.
In the full mode the entire data dictionary is read and the DDL
necessary to create the ORACLE database can be directed to a
dump file. In the User mode only the specific users objects
are are exported and in the Table mode only the specific table
or tables are exported. This utility can be run interactively
or from a parameter file. In the interactive mode you can execute
all the options from one line or after issueing the "exp" command
hit a return to be prompted for the information. For help or
details on this utility and the parameters used you should consult
the ORACLE Utilities Guide or you may see the optional parameters
displayed to your terminal by executed the following command:
$ exp help=Y
The following example shows two export modes; full and table mode.
Prior to issuing this command make sure your ORACLE_HOME and
ORACLE_SID enviroment variables are set and the ORACLE instance
is up by issueing ps -ef | grep ora_ | grep $ORACLE_SID.
Export Full
-----------
$ exp system/manager full=Y file=full_database.dmp grants=y indexes=y
Export Table(s)
---------------
$ exp system/manager tables=(a, sports.item, customer)
IMPORT UTILITY
--------------
The import utility reterives the ORACLE database or table data
found in the export format files into the database.
Import Full
-----------
$ imp system/manager file=full_database.dmp full=Y commit=Y
Import Table(s)
---------------
$ imp system/manager tables=(a, sports.item, customer)
NOTE: For futher assitance on either of the aforementioned
ORACLE utilities consult your ORACLE documentation.
Progress Software Technical Support Note # 13994