Oracle Export Import Utility

In this article, we will learn about the traditional Oracle Export and Import utility

• Oracle Export

• Oracle Import

Oracle Export

To know options of export

$ exp help=y

To take full database level export

$ exp file=/u01/fullbkp_prod.dmp log=/u01/fullbkp_prod.log full=y

To take schema level export

$ exp file=/u01/scott_bkp.dmp log=/u01/scott_bkp.log owner='SCOTT'

To take table level export

$ exp file=/u01/emp_bkp.dmp log=/u01/emp_bkp.log tables='SCOTT.EMP'

To take row level export

$ exp file=/u01/emp_rows_bkp.dmp log=/u01/emp_rows.log tables='SCOTT.EMP' query=\"where deptno=10\"

Oracle Import

To know options of import

$ imp help=y

To import full database

$ imp file=/u01/fullprod.dmp log=/u01/imp_fullprod.log full=

To import a schema

$ imp file=/u01/scott_bkp.dmp log=/u01/imp_schema.log fromuser='SCOTT' touser='SCOTT'

To import a table

$ imp file=/u01/emp_bkp.dmp log=/u01/imp_emp.log fromuser='SCOTT' touser='SCOTT' tables='EMP'

To import a table to another user

$ imp file=/u01/emp_bkp.dmp log=/u01/imp_emp.log fromuser='SCOTT' touser='SYSTEM' tables='EMP'