• Arun Kumar

Oracle Export Import Utility

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


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'

233 views

Recent Posts

See All

Add ISO image storage repository on XenServer

If you have used VMware ESXI, its very easy to upload ISO files to the data store and create VMs. With Citrix XenServer, you must create your own ISO repository to upload ISO files. Create ISO directo

Oracle Home Cloning

Have you ever imagine how easy it would be if you could just clone an existing installation of Oracle Software from one server to another server without performing a fresh installation! You might have

Oracle External Tables

Oracle SQL*Loader engine allows you to query external tables that are stored on flat files. When I say flat files, I literally mean a file that is stored on OS level. Yes, you can query a flat file th