| Export utility is very popular backup utility of Oracle. | | | | data. Unnecessary our export dump file becomes |
| Export backup calls as Logical backup of Oracle. | | | | large. |
| Many developers and DBA are using export of Oracle | | | | When we are take full backup of database using |
| database as backup. | | | | export utility (exp full=y), same time we can't able to |
| People use export because it is very easy to operate. | | | | exclude some tables which really we don't want to |
| There are very few command should be need to | | | | take backup. Because export utility doesn't perform |
| execute with export (exp help=y) command and it | | | | deselect any table in full database export or user level |
| takes full Oracle database backup. Without knowledge | | | | export. Using expdp we can exclude some table but |
| of Oracle DBA operations also able to take backup of | | | | this new feature was introduced in Oracle 10g. What |
| full Oracle database using export utility. Using export | | | | about previous release? |
| utility a file is generated calls Dump file because it has | | | | Using one trick we can exclude some tables in export |
| default extension .dmp. | | | | backup. Change sql of view exu10tab or exu9tab, it |
| Recovery of Oracle database is also simple from | | | | can be possible. Off course changing data dictionary |
| export. Import utility calls recovery utility of Oracle | | | | view doesn't supported by Oracle, but we can able to |
| database. Import utility easily detects export dump file. | | | | perform our backup of Oracle database task for |
| Like export utility, import (imp help=y) utility has also | | | | excluding some unwanted tables. |
| very few commands to perform recovery of Oracle | | | | Use Oracle Enterprise Manager or Toad like utilities to |
| database. | | | | change this sql statement (definition) of data |
| Using import utility we can recover full database. | | | | dictionary view. Those are very easy options to |
| A characteristic of export and import utility is it can be | | | | modify such sql statement. It doesn't recommend to |
| done user level, table level or full database. Means we | | | | change this definition of Data Dictionary view because |
| can take backup of single table or single user level or | | | | it is not supported by Oracle Support. This we can do |
| whole database and recovery can be performed | | | | for performing our important task when space usage |
| using import in different level. | | | | is constraint in more important. From Oracle 10g expdp |
| Export and Import becomes more popular due to easy | | | | contain parameter named EXCLUDE. We can give list |
| to understand and easy to perform. | | | | of tables which are wanted to not taking in backup for |
| One problem I found that is we are not able to exclude | | | | saving our disk space and not wasting time. But for |
| some tables during full export backup or user level | | | | past release of Oracle database this trick is useful to |
| export backup. Some of tables are read only tables or | | | | avoid such read only tables and unwanted table for |
| never refresh. Then we should need to exclude those | | | | saving disk space and saving time of backup of |
| tables from our backup because it is useless to take | | | | Oracle database. |
| backup of those tables again and again with same | | | | |