Oracle documentation says, Oracle Data Pump utilities are designed for enhanced performance especially for large databases. For large volume database a dramatic increase in performance should be experienced in compared to the original Export and Import utilities. Moreover original Export (exp
) or Import (imp
) utilities are de-supported for general use as of Oracle Database 12c. Therefore, Oracle recommends to use the new Data Pump Export (expdp
) and Import (impdp
) utilities, except the case where you want to import files that were created using the original Export utility (exp
).
There are some fundamental differences between original utilities and Data Pump utilities. Those are,
- Data Pump uses parallelism to export large database in lesser time.
- Data Pump technology fully uses all available resources to maximize throughput and minimize elapsed job time.
- Dump files are read and written directly by the server and, therefore, do not require any data movement to the client.
- The database administrator (DBA) must create directory objects that define the server locations to which files are written.
In recent version of Ginesys (above 11.147.5), Oracle 12c database (12.1.0.2.0) is the only supported Oracle version . Also the original export utility (ref. Notification: Ginesys no longer supports Oracle 10g). Original Oracle backup utility (exp
) is not capable to do a successful complete export of Ginesys database (12c) as exp
fails to export some advanced functionality in Oracle 12c. Ginesys already released the revamped backup utility based on take export of all objects mainly where advanced features of 12c are implemented. Oracle has already officially de-supported the old utilities (exp & imp
) and guided to use Oracle Data Pump utilities (expdp & impdp
) to export or import database. Ginesys, release 11.147.8 onward, already revamped Database backup utility and it now uses Oracle Data Pump Export utility (expdp
) in release 11.147.8. To as backup agent. To accommodate the changes in new Oracle utility Ginesys backup utility has also changed. Now there are some specific requirement requirements to select the backup location. This article will help you to select the backup location for Ginesys Backup utility.
Single server deployment (application and database on the same server):
...
...
imp
). As a result, any backup created by expdp
utility cannot be restored using Ginesys DB Restore utility. Manual restoration required.
Related Article
How To: Backup and Restore Oracle database manually using Data Pump Export and Import
...