<<Previous Next>>
Oracle - What are the
original Export and Import Utilities? - Feb 07, 2010 at
14:20 PM by Shuchi Gauri
What are the original Export and Import Utilities?
SQL*Loader, External
Tables
Oracle - What
are the original Export and Import Utilities? - April 10, 2009
at 11:00 AM
What are the original Export and Import
Utilities?
- The import and export utilities of oracle provide a very
simple way to transfer data objects between Oracle databases.
These may reside on heterogeneous software and hardware platforms.
- The exported data objects are extracted and written to an
export dump file.
- The Import utility reads the object definitions and table data
from the dump file.
- An export file is an Oracle binary-format dump file located on
disk or tape which can be transferred by using FTP or physically
transported. They can then be used with the Import utility to
transfer data between databases on a single system. The files can
also be used as backups in addition to normal backup procedures.
- Export and Import utilities are now being replaced by Data
Pump Export and Import utilities in Oracle 10g.
Also read
What are the use of Export and Import command?, What are the
parameters to be provided while executing Export and Import
commands?, What is the difference between the SQL*Loader and IMPORT
utilities?..............
Import and Export utilities are helpful in following ways: They
can be used for backup and recovery process, they can also be used
while moving database between two different...............
Data pump export and import modes are used to determine the type
and portions of database to be exported and
imported:................
|
