Do More with Data Pump: Tips and Techniques

Datapump was introduced in Oracle Database 10g, and has evolved over the versions with various features and performance improvements to migrate data and objects. The legacy export (exp) / import (imp) utility is still maintained in all versions of database including 12c for backward compatibility, and to migrate legacy data to newer versions of database. In this session the speaker shows you how to extend datapump for your various data and object migration needs outside of copying a table or schema. You will learn to export public and private database link and synonyms, various object filtering and row filtering techniques, improving performance of data pump operations, migrate data without using any space for dump file, changing storage properties during export and import, and methods to verify the contents of export dump file.

Thursday, 2016-11-17
4:00 pm - 4:45 pm
Neu Delhi
advanced
English
Database
Thomas

Biju Thomas

OneNeck IT Solutions
Oracle ACE-Director
Biju Thomas is Oracle ACE Director, Oracle Certified Professional and Certified Oracle Database SQL Expert. He is Principal Solutions Architect at OneNeck IT Solutions. Biju has been developing and administering Oracle databases since 1993 and Oracle EBS since 2006. He spends time mentoring DBAs, performance tuning, and architecting Oracle solutions. He is a frequent presenter at Oracle conferences and writes articles for Oracle technical journals. He has authored Oracle certification books published by Sybex since Oracle8i, all versions including Oracle Database 12c OCA. Biju blogs at http://www.bijoos.com/oraclenotes and you can follow him on Twitter (@biju_thomas) or Facebook (oraclenotes) for daily Oracle Tidbits.

These lectures could also interest you