• 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'




Recent Posts

See All

Perform Manual Switchover on Physical Standby

Connect to proddb database via client: Take a new putty session and connect to proddb database via client machine. Keep querying below sqlplus sys/sys@proddb as sysdba SQL> select name, open_mode, db

How to check database backups

Checking Database backups are one of the main focus areas of a DBA. Time to time, DBA needs to check database backup status and see if its completed, failed, running etc. Also, DBA must be able to get

Automate RMAN Backups using Shell Scripts

In a real environment, off course you will not manually trigger all the Oracle database backups. You need an automated mechanism to trigger RMAN backups. In this article we will look at RMAN backup au

  • Facebook
  • Twitter
  • YouTube
  • Instagram

© 2020 by DBA Genesis

Feedback