Look for the "imp" and "exp" executables in your $ORACLE_HOME/bin
directory. One can run them interactively, using command line
parameters, or using parameter files. Look at the imp/exp parameters
before starting. These parameters can be listed by executing the
following commands: "exp help=yes" or "imp help=yes".
The following examples demonstrate how the imp/exp utilities can be
used:
exp scott/tiger file=emp.dmp log=emp.log tables=emp rows=yes
indexes=no
exp scott/tiger file=emp.dmp tables=(emp,dept)
imp scott/tiger file=emp.dmp full=yes
imp scott/tiger file=emp.dmp fromuser=scott touser=scott
tables=dept
exp userid=scott/tiger@orcl parfile=export.txt
... where export.txt contains:
BUFFER=100000
FILE=account.dmp
FULL=n
OWNER=scott
GRANTS=y
COMPRESS=y
NOTE: If you do not like command line utilities, you can import and
export data with the "Schema Manager" GUI that ships with Oracle
Enterprise Manager (OEM).