Database Reference
In-Depth Information
Step 2: Run & provide your Oracle credentials to Export utility
You must be having this utility available under
$ORACLE_HOME/bin directory having the name exp. At the
Unix or Windows NT/Server/XP prompt write exp.
C:\> exp
Then provide your Oracle credentials i.e. login/password that
you use to connect to Oracle database. Actually Export utility
will use your credentials to make a connection with the Oracle
database whose SID you have assigned to ORACLE_SID
operating system environment variable in step 1.
Username: system
Password: manager
Step 3: Answer questions asked by Export Utility
After getting your credentials (login/password) Export utility
will ask you certain question before exporting data out to
external dump file. The first question would be the buffer size
you want to use to facilitate the fetching of data. The default size
would be 4096K. If you want to stick with this default size then
simply press Enter key.
Enter array fetch buffer size: 4096>
Then the Export utility will ask for the external dump file name.
Provide the full qualified name including the path where you
want to store this file. The extension of this dump file should be
.dmp whereas the file name could be any name, in our case we
are using the file name same as that of table name we want to
export i.e. emp table. The default name of dump file is
expdat.dmp. If you want to stick with this press the Enter key.
Export file: expdat.dmp> emp.dmp
Next question will ask for Users or Tables. If you want to export
table then select the table option whereas if we want to export
Search WWH ::
Custom Search