Blogs about: Expdp
Featured Blog
DBMS_DATAPUMP using the API
My challenge was to move a schema from one database to another, simple enough one would assume however I had several limitations. I could not use transportable tables because the charactersets were di… more →
Oracle DBA - A lifelong learning experience
10g Datapump - An Introduction
Arjun Raja wrote 5 months ago: In 10g you can continue to use the earlier exp and imp versions to export/import data. However if yo … more →
DBMS_DATAPUMP using the API
— 1 comment
John Hallas wrote 7 months ago: My challenge was to move a schema from one database to another, simple enough one would assume howev … more →
Optimizing Import/Export
mohibalvi wrote 7 months ago: EXPORT: Set the BUFFER parameter to a high value (e.g. 2Mb — entered as an integer "20000 … more →
keep data consistency when using oracle exp/expdp
zhefeng wrote 8 months ago: When we were using old oracle exp, we usually will set exp consistent=y (default is n) to ensure the … more →
EXPDP and IMPDP
mohibalvi wrote 8 months ago: Detailed Documentation of EXPDP Detailed Documentation of IMPDP Data Pump is server-based, rather th … more →
Where has consistent=y gone when using Datapump export
— 1 comment
John Hallas wrote 1 year ago: Well it is not needed anymore according to Oracle. Let’s take a look at a bit of history. From 9i, w … more →
How to monitor datapump?
Amin Jaffer wrote 1 year ago: When using datapump one can run the following query to monitor the progress by running the following … more →
