Oracle Data Pump is faster and more flexible alternative to the “exp” and “imp” backup system used in previous Oracle versions. impdp and expdp commands use Oracle Directory for processing of backups.<\/p>\n
Create Directory<\/strong><\/p>\n \nCONN SYS AS SYSDBA Tables Export and Import<\/strong><\/p>\n \nexpdp backupuser\/password@db tables=EMPLOYEES,COUNTRY directory=dirname dumpfile=backupdumpfilename.dmp logfile=logfilenameforexp.log<\/p>\n impdp backupuser\/password@db tables=EMPLOYEES,COUNTRY directory=dirname dumpfile=backupdumpfilename.dmp logfile=logfilenameforimp.log\n<\/p><\/blockquote>\n Schema Export and Import<\/strong><\/p>\n \nexpdp backupuser\/password@db schemas=HR directory=dirname dumpfile=backupdumpfilename.dmp logfile=logfilenameforexp.log<\/p>\n impdp backupuser\/password@db schemas=HR directory=dirname dumpfile=backupdumpfilename.dmp logfile=logfilenameforimp.log\n<\/p><\/blockquote>\n Remap Schema<\/strong><\/p>\n \nimpdp backupuser\/password@db directory=dirname remap_schema=SourceSchema:TargetSchema dumpfile=fullbackupdumpfilename.dmp logfile=logfilenameforimp.log\n<\/p><\/blockquote>\n <\/p>\n Table Export and Import From Full Backup With include and exclude<\/strong><\/p>\n The INCLUDE and EXCLUDE parameters can be used to limit the export\/import to specific objects. When the INCLUDE parameter is used, only those objects specified by it will be included in the export\/import. When the EXCLUDE parameter is used, all objects except those specified by it will be included in the export\/import. <\/p>\n \nimpdp backupuser\/password@db schemas=HR include=TABLE:”IN (‘TBL1’, ‘TBL2’)” directory=dirname dumpfile=backupdumpfilename.dmp logfile=logfilenameforimp.log<\/p>\n impdp backupuser\/password@db schemas=HR exclude=TABLE:”= ‘TBL5′” directory=dirname dumpfile=backupdumpfilename.dmp logfile=logfilenameforimp.log\n<\/p><\/blockquote>\n Import Only One Table From Full Backup With Remap<\/strong><\/p>\n impdp backupuser\/password@db schemas=HR remap_schema=SourceSchema:TargetSchema include=TABLE:”IN (‘TBL1’, ‘TBL2’)” directory=dirname dumpfile=backupdumpfilename.dmp logfile=logfilenameforimp.log <\/p><\/blockquote>\n Full Export and Import<\/strong><\/p>\n \nexpdp backupuser\/password@db full=y directory=dirname dumpfile=fullbackupdumpfilename.dmp logfile=logfilenameforexp.log<\/p>\n impdp backupuser\/password@db full=y directory=dirname dumpfile=fullbackupdumpfilename.dmp logfile=logfilenameforimp.log\n<\/p><\/blockquote>\n After taking a full backup, you can turn from full backup as schema by schema.<\/p>\n \nimpdp system\/password@db schemas=HR directory=dirname dumpfile=fullupdumpfilename.dmp logfile=logfilenameforimp.log\n<\/p><\/blockquote>\n","protected":false},"excerpt":{"rendered":" Oracle Data Pump is faster and more flexible alternative to the “exp” and “imp” backup system used in previous Oracle versions. impdp and expdp commands use Oracle Directory for processing of backups. Create Directory CONN SYS AS SYSDBA CREATE OR REPLACE DIRECTORY dirname AS ‘\/u01\/backup\/’; GRANT READ, WRITE ON DIRECTORY dirname TO backupuser; Tables Export…<\/p>\n","protected":false},"author":37,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[9,20],"tags":[14,90,32],"class_list":["post-675","post","type-post","status-publish","format-standard","hentry","category-administration","category-oracle-backup-and-recovery","tag-database-administration","tag-oracle","tag-oracle-administration"],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p39NFI-aT","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/675","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/users\/37"}],"replies":[{"embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/comments?post=675"}],"version-history":[{"count":7,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/675\/revisions"}],"predecessor-version":[{"id":1360,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/posts\/675\/revisions\/1360"}],"wp:attachment":[{"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/media?parent=675"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/categories?post=675"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.fatihacar.com\/blog\/wp-json\/wp\/v2\/tags?post=675"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\nCREATE OR REPLACE DIRECTORY dirname AS ‘\/u01\/backup\/’;
\nGRANT READ, WRITE ON DIRECTORY dirname TO backupuser;\n<\/p><\/blockquote>\n