IMP- EXP

CREATE DIRECTORY data_pump_dir AS '/usr/dba/dpumpfiles'
expdp hr/hr DUMPFILE=emp.dmp LOGFILE=emp.log TABLES=hr.employees
create directory pilot_bkp as 'I:\Pilot_Backup';select DIRECTORY_NAME,substr(DIRECTORY_PATH,1,100) from DBA_DIRECTORIES;
create directory bkpilrpoly as '/oradata/backup/backup_ilrpoly/';grant
grant read, write on directory ORCL_bkp to system;
CREATE DIRECTORY ilrpoly_dir AS '/oradata/backup/backup_ilrpoly';grant ilrpoly read, write on directory ilrpoly_dir to system;grant read, write on directory exp_dump to ilrpoly;
expdp system/sys@ilrpoly directory=ilrpoly_dir DUMPFILE=ILRPOLY_FULLEXP_TODAY.dmp LOGFILE=ILRPOLY_FULLEXP_TODAY.log full=y;
expdp system/sys@pilot directory=pilot_bkp DUMPFILE=Pilot_test.dmp LOGFILE=Pilot_test.log full=y;
SELECT OBJECT_PATH, COMMENTS FROM SCHEMA_EXPORT_OBJECTS2 WHERE OBJECT_PATH LIKE '%GRANT';
impdp sde/sde network_link=osiidb2rds tables=rds_photo.USSTATE remap_schema=rds_photo:sde EXCLUDE=CONSTRAINT REMAP_TABLESPACE=PHOTO_rds:sde
impdp wg5386/wg5386 network_link=pilot2rds tables=rds_photo.USSTATE remap_schema=rds_photo:wg5386 EXCLUDE=CONSTRAINT REMAP_TABLESPACE=PHOTO_rds:wg5386
create directory rds_backup as 'd:\rds_Backup';
create directory rds_backup as 'L:\';
create directory rds_backup as '/prod/backup/RDS/logical_backup/';grant read, write on directory rds_backup to system;
create directory pizza_backup as '/prod/backup/pizzahut/logical_backup/';grant read, write on directory rds_backup to system;
create directory rdsbackup as '/prod/data_backup/rds/';grant read, write on directory rdsbackup to system;
create directory ligbackup as '/prod/data_backup/lig/';grant read, write on directory rdsbackup to system;
grant read, write on directory pilot_bkp to system;
create directory geozip_bkp as 'F:\GEOZIP_BKP'grant read, write on directory geozip_bkp to system;expdp system/sys@pilot directory=geozip_bkp DUMPFILE=geozip_bkp_test.dmp LOGFILE=geozip_bkp_test.log schemas=GEOZIP
impdp system/sys directory=rds_backup dumpfile=EXP_RDS_WED_MORNING.DMP tables="USSTATE" REMAP_SCHEMA=RDS_PHOTO:sde REMAP_TABLESPACE=PHOTO_rds:sde
impdp system/sys directory=rds_backup dumpfile=EXP_RDS_WED_MORNING.DMP tables=rds_photo.USSTATE REMAP_SCHEMA=RDS_PHOTO:sde REMAP_TABLESPACE=PHOTO_rds:sde
exp system/system@admin1 file=fullexp.dmp log=fullexp.log owner='att','subtest','s7_db','sb_db','depr'
impdp rds/rds@rds directory=rds_backup dumpfile=EXP_RDS_MON_MORNING.DMP tables=rds.FARES_SC_KY_0207_V3 cONTENT=DATA_ONLY
exp system/sys@ilrpoly file=I:\ilrpoly_fullexp_18th_Apr.dmp log=I:\ilrpoly_fullexp_18th_Apr.log full=y buffer=200000 direct=y;imp sde/sde@osiiidb fromuser = sde touser=sde file=D:\OSIIIGC1_BACKUP\exp_OSIIIGC1_Mon_morning.dmp log =d:\uks_report.txt tables=tblinputvision ,tblgelsvision,tblerrorvision,tblqcerrorvision,tbluservision,tbloutputvision,tblprojectdetailvision