Import “IMP” and Export “EXP” are among the oldest surviving Oracle tools. India also play the Contributions for Import (IMP) and Export (EXP) with Indian Exporters and Indian Importers. They are command line tools used to extract tables, schemes, or entire database definitions from one Oracle instance, to be imported into another instance or schema.
According to India: Traditionally, Import and Export have been considered to be in the domain of the DBA (Doing Business As). But it is more useful to the individual developer than as a DBA tool. As databases have grown, both in size and importance, the tools needed to manage them have grown as well. With small databases today starting in the gigabytes range, simple tools that process everything serially such as import and export, just do not scale.
While not useless to the DBA, they are definitely not as useful as they once were. Other tools and methods have come along to take their place. For i.e. we would now use Recovery Manager "RMAN" to perform an incremental backup of very large databases, not EXP. They still have many other uses such to detect logical and physical corruption, to transport data files from database to data etc.
Why You might Use Import and Export
IMP and EXP are tools you will probably use at some point or another. Export has many uses, some are briefly mentioned. Here some of the situations where Export is find useful. Detecting Corruption
Export can be used as a tool to proactively find corruption, whether is related to logical or physically, in a database. If you use Export to perform a full database EXP, it will completely exercise the data dictionary, detecting almost any logical dictionary corruption for us. Additionally, only it has the capability of full scan every table in your database, reading out all the rows. If there is a table with a bad block, this is bound to find it.
Cloning Schemes
Import (IMP) and Export (EXP) can be used to clone a schema for testing. Using the from user and to user options of the Import (IMP) command, we can easily export data from one user account to another.
Know More:-
Indian Exporters
According to India: Traditionally, Import and Export have been considered to be in the domain of the DBA (Doing Business As). But it is more useful to the individual developer than as a DBA tool. As databases have grown, both in size and importance, the tools needed to manage them have grown as well. With small databases today starting in the gigabytes range, simple tools that process everything serially such as import and export, just do not scale.
While not useless to the DBA, they are definitely not as useful as they once were. Other tools and methods have come along to take their place. For i.e. we would now use Recovery Manager "RMAN" to perform an incremental backup of very large databases, not EXP. They still have many other uses such to detect logical and physical corruption, to transport data files from database to data etc.
Why You might Use Import and Export
IMP and EXP are tools you will probably use at some point or another. Export has many uses, some are briefly mentioned. Here some of the situations where Export is find useful. Detecting Corruption
Export can be used as a tool to proactively find corruption, whether is related to logical or physically, in a database. If you use Export to perform a full database EXP, it will completely exercise the data dictionary, detecting almost any logical dictionary corruption for us. Additionally, only it has the capability of full scan every table in your database, reading out all the rows. If there is a table with a bad block, this is bound to find it.
Cloning Schemes
Import (IMP) and Export (EXP) can be used to clone a schema for testing. Using the from user and to user options of the Import (IMP) command, we can easily export data from one user account to another.
Know More:-
Indian Exporters
No comments:
Post a Comment