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 !
Category Archives: EXPDP
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