Oracle Data Dump Import and Export

Login to server :
sqlplus / as sysdba

exp SYSTEM/password FULL=y FILE=dba.dmp LOG=dba.log CONSISTENT=y

or

exp SYSTEM/password PARFILE=param.dat

where param.dat contains the following information 

FILE=dba.dmp 
GRANTS=y 
FULL=y 
ROWS=y 
LOG=dba.log

To dump a single schema to disk.

exp / FILE=dump.dmp OWNER=production

Export Specific tables to disk

exp SYSTEM/password FILE=export.dmp TABLES=(user1.table,user2.table)

Export Data in one user 

exp / FILE=export.dmp TABLES=(table1,table2)

Using imp: 

To import the full database exported in the example above.

imp SYSTEM/password FULL=y FIlE=dba.dmp

To import just the dept and emp tables from the scott schema

imp SYSTEM/password FIlE=dba.dmp FROMUSER=scott TABLES=(dept,emp)

To import tables and change the owner 

imp SYSTEM/password FROMUSER=blake TOUSER=scott FILE=blake.dmp TABLES=(unit,manager)

To import just the scott schema exported in the example above

imp / FIlE=scott.dmp