Using export utility in Oracle Database

Sept. 19, 2010 - PRLog -- Export utility is very popular backup utility of Oracle. Export backup calls as Logical backup of Oracle. Many developers and DBA are using export of Oracle database as backup.

People use export because it is very easy to operate. There are very few command should be need to execute with export (exp help=y) command and it takes full Oracle database backup. Without knowledge of Oracle DBA operations also able to take backup of full Oracle database using export utility. Using export utility a file is generated calls Dump file because it has default extension .dmp.

Recovery of Oracle database is also simple from export. Import utility calls recovery utility of Oracle database. Import utility easily detects export dump file. Like export utility, import (imp help=y) utility has also very few commands to perform recovery of Oracle database. Using import utility we can recover full database.

A characteristic of export and import utility is it can be done user level, table level or full database. Means we can take backup of single table or single user level or whole database and recovery can be performed using import in different level.

Export and Import becomes more popular due to easy to understand and easy to perform.

One problem I found that is we are not able to exclude some tables during full export backup or user level export backup. Some of tables are read only tables or never refresh. Then we should need to exclude those tables from our backup because it is useless to take backup of those tables again and again with same data. Unnecessary our export dump file becomes large.

When we are take full backup of database using export utility (exp full=y), same time we can't able to exclude some tables which really we don't want to take backup. Because export utility doesn't perform deselect any table in full database export or user level export. Using expdp we can exclude some table but this new feature was introduced in Oracle 10g. What about previous release?

Dbametrix offers expert remote DBA services for remote database monitoring with very low cost. Dbametrix is offering remote database services as per service level agreement for guaranteed high availability of database and maximum performance.  Dbametrix has own high qualify, experienced and certified team of Oracle DBA. Dbametrix offers guaranteed satisfaction with our remote oracle dba services. Dbametrix provides very flexible remote dba plans which fit to client requirement and budget. Dbametrix is providing 24*7 remote dba support using Service Level Agreement.

About The Author:  Dbametrix is expert team of high qualified Remote DBA and offers very flexible cheapest cost plan.   http://www.dbametrix.com   offers Remote DBA support and remote Oracle DBA services. All copyright reserved by @Dbametrix. Contact mailto:info@dbametrix.com  or at  http://www.dbametrix.com/database_support.html

# # #

Expert remote Oracle DBA team offers remote dba support,remote dba services,remote dba work,remote database monitoring,database services,outsourcing with very low cost plan using SLA.