—– Create user for using EXPDP/IMPDP : create user admin identified by PW; grant connect,resource to admin; grant unlimited tablespace to admin; grant create any view to admin; create or replace directory DBA_EXPORT as ‘/u01/app/oracle/admin/cloud12c/dpdump’ grant write on directory DBA_EXPORT to admin; grant EXP_FULL_DATABASE to… Read More

To do a selective data export in a table using expdp, query option can be used, provided if the where condition doesn’t have any subqueries.For any Query Export Dumps, having Sub query should be using a parfile instead of the direct expdp command.All the complex… Read More