Total Pageviews

September 9, 2015

9/09/2015 12:34:00 AM
There are so many techniques for High Speed Oracle Data Extract and Reload.
Have a look on those technologies

Data Pump - Here are my tips for speeding up Oracle expdp (Data Pump).  You can also tune the import utility (impdb) for faster performance.
The Data Pump export utility provides a mechanism for transferring data objects between Oracle databases.
ex: $expdp scott/tiger DIRECTORY=data_pump_dir DUMPFILE=scott_schema.dmp  SCHEMAS=SCOTT

Data Pump Import (hereinafter referred to as Import for ease of reading) is a utility for loading an export dump file set into a target system. The dump file set is made up of one or more disk files that contain table data, database object metadata, and control information.
The files are written in a proprietary, binary format. During an import operation, the Data Pump Import utility uses these files to locate each database object in the dump file set.

Import can also be used to load a target database directly from a source database with no intervening dump files. This is known as a network import.

Data Pump Import enables you to specify whether a job should move a subset of the data and metadata from the dump file set or the source database (in the case of a network import), as determined by the import mode. This is done using data filters and metadata filters, which are implemented through Import commands. See Filtering During Import Operations.

Solid-state disk - SSD is hundreds of times faster than disk, and it's perfect for super-fast unload/reload migrations.

Solid state devices, colloquially known as SSDs, or solid state drives, have been around for some time now, but especially with the onset of the Oracle Database Machine X2-2 and its corresponding Exadata Storage Server, interest in utilizing SSDs has increased exponentially. In truth, the advantages of SSDs are not that difficult to grasp because the IT community has actually been using them for at least a decade, but in a much smaller format: USB ("thumb") drives incorporate the same technology as does any SSD, albeit on a much smaller scale.

SSDs are essentially composed of NAND "flash memory." However, note that this is most definitely not the same type of memory that’s used for cache memory SAN platforms or DRAM in database servers. SSDs are manufactured in two basic architectures, single-level cell (SLC) and multiple-level cell (MLC).

courtesy:Database Journal

SQL Loader - You can make SQL*Loader run very fast with tuning tips.
SQL Loader Basics with examples

Database to database - Here is a clever technique using Linux with direct export/import, with no intermediate flat files.

CTAS - You can use parallelized "create table as select" over a high-speed database link to quickly move tables between Oracle databases.

Fact & CoSort - Fast Extract (FACT) for Oracle unloads large tables in parallel to flat files.  FACT also writes the file layout metadata that CoSort can use for reload (reorg, ETL) pre-sorts, plus join and aggregate transforms, report generation, field-level security, etc.  For more information about these tools click here.

For further details please visit

Vendor tools - Vendors such as BMC and Wisdomforce offer tools for super-fast table unloading from Oracle.  Also, unload/reloads happen super-fast on SSD hardware.
Related Posts Plugin for WordPress, Blogger...