image

Why expdp is faster than regular exp?

Solutions: 1. expdp is faster due to parallelism. 2. expdp is more advanced. 3. expdp is direct path export which is Oracle Data block. Exp uses SQL level extraction. 4. Exp,imp runs on client side, but expdp and impdp runs on server side.so we have much control compared to traditional exp,imp !  

image

errors at datapump impdp expdp – ORA-39213: Metadata processing is not available

When i tried to export the database using the expdmp with the following command $expdp username/password dumpfile=export.dmp logfile=export.log full=y parallel=4 I got the following error. Error: With the Partitioning, OLAP and Data Mining options ORA-39006: internal error ORA-39213: Metadata processing is not available   How i solved it ? $sqlplus / as sysdba SQL>execute dbms_metadata_util.load_stylesheets … continue reading

Visit Us On FacebookVisit Us On Google PlusVisit Us On Youtube