Besides the CLI interface, it is used by Enterprise Manager, SQL*Loader (by means of the external data pump table driver), the PL/SQL API, and other clients.ĭata Pump is a productive tool designed to make the DBA's life easier. It is an efficient, manageable, adaptive tool that can be used in more than one mode namely, the regular command line interface, the suspended mode, the network mode, and the PL/SQL API mode. It enables high speed data and metadata transfers.
Oracle Data Pump is a facility available since Oracle 10g Release 1.
DIFFERENCE ORACLE 10G AND 11G CODE
In turn, the data pump Application Programming Interface(API) allows a programmer to embed data pump code inside a regular PL/SQL application so that it manages its own data without requiring a direct Database Administrator (DBA) or Database Owner(DBO) intervention.īetter performance and more manageability than the old export/import It can remap data object definitions, and access them by means of either a Command Line Interface(CLI) batch or interactive interface. It was the Data Pump.ĭata Pump allows better manageability, and performance it can be parameterized to meet particular data management requirements, such as direct export/import operations between different databases (or even different versions, starting with 10g Release 1). When 10g first appeared, a complete re-engineering took place and a new product was conceived to meet today's data management requirements. Let's remember that export/import has been available in Oracle for a very long time, it dates back to Oracle Release 5, and it has been adapted to incorporate some meaningful new features. Managing high volumes of data becomes impractical if we take the traditional export/import approach, as this tool is very limited. Storage technology is improving day by day, and the more storage that becomes available at a low cost, the more data appears to fill it up.
0 kommentar(er)
