Database Reference
In-Depth Information
Command-Line Export:
The Export utility can be used in the command line as follows
where we provide all the parameters in the single command.
Before running this command make sure you set the
ORACLE_SID operating system environment variable.
> exp system/manager tables=(emp, dept) grants=Y indexes=Y direct=y
You can also get a detailed help on Export utility by running the
following command at the OS prompt.
>exp -help
The Import utility is located under ORACLE_HOME/bin
directory in Unix and ORACLE_HOME\bin directory in
Windows NT/XP/Server 2003. The utility comes with a detailed
help too and can be accessed by running the following command
at the operating system prompt.
>imp -help
With the help of Import utility we can import any previously
exported logical objects using Export utility in any Oracle
database. The step by step process of importing any .dmp file
into the Oracle database is given below.
Step 1: Set ORACLE_SID
Make sure that ORACLE_SID is set to the SID of Oracle
database to which you want to import the file.
Step 2: Run & provide your Oracle credentials to Import utility
The Import utility is located under ORACLE_HOME/bin
directory and can be executed simple by writing imp. Then
supply your Oracle username/password. The Import utility will
use your credentials to make a connection with the Oracle
Search WWH ::




Custom Search