Database Reference
In-Depth Information
the complete schema i.e. all the object under the user account
then select the user option. By default its users.
(2) U(sers), or (3)T(ables): (2)U> 3
Then the next prompt would be to have extents compressed by
default its yes.
Compress extents (yes/no): y
Lastly, it will ask for the table or partition that needs to be
exported.
Table or Partition to be exported> emp
With the answer to this question, the export utility will start
exporting emp data out from Oracle in the binary dump file and
once done it will terminates with the success and you will be
back on the OS prompt.
PARFILE Export:
First set the ORACLE_SID operating system environment
variable then create a separate text file having all the parameters
lined up as follows and then run Export utility specifying
PARFILE parameter.
> exp system/manager parfile=param.dat
Where param.dat file contains the following information:
DIRECT=Y
FILE=expdat.dmp
TABLES=(scott.emp,blake.dept)
GRANTS=y
INDEXES=y
Search WWH ::
Custom Search