***********************************************************************************For DataPump YOu need to create the Directory where BAckup will be stored.
CREATE DIRECTORY ABC_dir AS '/oradata/backup/backup_ABC';
Then Grant the User who will perfomr the Export (sys is by default granted).
grant read, write on directory ABC_dir to system;grant read, write on directory ABC_dir to ilrpoly;
expdp system/sys@ilrpoly directory=ABC_dir DUMPFILE=ABC_FULLEXP_TODAY.dmp LOGFILE=ABC_FULLEXP_TODAY.log full=y;****************************************************************************************************************For Importing user need to copy the file in the Creted directory .This will Not Import from any path.
impdp system/sys directory=ABC_backup dumpfile=EXP_ABC_WED_MORNING.DMP tables="USSTATE" *****************************************************************************************Ref = Part No. B10825-01
*******************************************************************************************
No comments:
Post a Comment