Excluding tables while performing datapump import from Full schema backup

Hello Everyone, In this article , we will learn Excluding tables while performing datapump import from full schema backup. Database : AVPROD Schema : OT Check objects count  in OT Schema.

Take full schema backup using schema=OT

Full schema backup completed ,… Read More

Oracle: Different options in Export and Imports

Different options in Export and Imports   Schema export and import using remap_schemas.   1) create directory dpump as ‘/u02/dpump’; 2) grant read,write on directory dpump to system;

For importing schema :   1) Cretae directory dpump as ‘/u02/DATAPUMP’; 2) grant read,write on directory… Read More