• Arun Kumar

Oracle Export Import Utility

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


Oracle Export


To know options of export


$ exp help=y

To take 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'




153 views

Recent Posts

See All

Oracle 12c to 19c Database Upgrade

In this article we will be looking at two most commonly used methods of upgrading Oracle database from 12c to 19c Pre-upgrade tasks Upgrade using DBUA Upgrade using Manual Method You can perform a dir

  • Facebook
  • Twitter
  • YouTube
  • Instagram

© 2020 by DBA Genesis