expdp
-
Expdp-Export data with query
Your table can have huge size or you may need to little piece of data from that huge table size. In that point you can use dblink or you can use export table data with query options. Here are the some quick steps. For exporting table data with query condition expdp “‘/ as sysdba’” Directory=xxxx Continue reading
-
How to use multiple paths during expdp& impdp
If your export size volume is huge than you may need to split export files instead of a single FS. In this case, We need to use the multiple directories feature of EXPDP or IMPDP utility. By using this feature, We can create multiple dump files in multiple directories and distribute our logical export to Continue reading
