Database Reference
In-Depth Information
Conventional path export takes more time for large amount of
data being transferred then the direct path export but it works
fine for everyday uses. In this method data is extracted by Export
utility from the database using SQL statement (SELECT *
FROM emp) and the result is dumped into the Database Buffer
Cache. From Buffer Cache, the data then gets evaluated in the
evaluating buffer then it gets dumped into the external binary
dump file.
In Direct path export there is no “evaluation of data” step
involved and the data gets transferred to the external dump file
from Database Buffer Cache. This elimination of one step results
in speedy transfer.
There are three ways we can run the Export utility. One is in the
“Interactive Mode”, second is the “Command-line” and the third
is by using parameter file i.e. PARFILE.
PARFILE method is basically used for nightly or scheduled or
automatic jobs to do the logical backup of data.
In Command line way, we describe all the parameters to run
Export utility in a single command where as in the Interactive
mode, the Export utility ask questions to get input from the user
regarding the parameters required to extract data.
Interactive Export:
Step 1: Set ORACLE_SID
Set the ORACLE_SID to the name of the Oracle Instance with
which you want the Export utility to communicate to extract the
information.
Search WWH ::
Custom Search