what is consistency =y in export ?

It makes all of the queries run by exp be “as of the same point in time– consistent with regards to eachother”Imagine if you started an export at 9am of the EMP and DEPT tables.EMP started exporting at 9am and DEPT at 9:15am.Now, the EMP data would be “as of 9am”, but the DEPT data … continue reading


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 we have much control compared to traditional exp,imp !  

Visit Us On FacebookVisit Us On Google PlusVisit Us On Youtube