Importing and Exporting Oracle Data for DBAs
As a DBA, you are constantly asked to create test schemas from production and sometimes move the entire database. In this course, you'll look at the Oracle Data Pump, a powerful tool which can help you perform these tasks easily and effectively.
What you'll learn
DBA are often asked to quickly create test schemas from production, or to move schemas, tablespaces, and tables between instances. In this course, Importing and Exporting Oracle Data for DBAs, you will learn how to move data and metadata between Oracle instances easily and effectively. First, you will explore the Oracle Data Pump tool, which is a very powerful and feature-rich tool. It provides a very fine-grained control for whatever you want to move, from the whole database to just a table with specific rows. Next, you will look at how to move schemas, tablespaces, and even the entire database. You will also explore how to move specific objects and the rich filtering capabilities of this tool. Finally, you will get a high-level overview of the transporting option to move data, which increases the performance significantly, and also briefly touch upon how Oracle Data Pump works with the Multitenant Architecture introduced with Oracle 12c. By the end of this course, you'll have a strong knowledge of importing and exporting Oracle data using the Oracle Data Pump.
Table of contents
- Module Overview 1m
- Schema Mode 5m
- LOGFILE 1m
- SQLFILE 2m
- ESTIMATE & ESTIMATE_ONLY 1m
- REMAP_SCHEMA 2m
- TRANSFORM Clause 2m
- Demo: Schema Export & Import 8m
- CONTENT Parameter 2m
- Demo: Moving Just the Schema Metadata 2m
- Demo: Moving Just the Schema Data 3m
- Disabling & Enabling Constraints 2m
- Demo: Disabling & Enabling Constraints 4m
- Disabling & Enabling Triggers 1m
- Demo: Disabling & Enabling Triggers 3m
- EXCLUDE & INCLUDE Parameters 3m
- Demo: EXCLUDE & INCLUDE Parameters 4m
- Moving Multiple Schemas 1m
- Demo: Moving Multiple Schemas 2m
- Summary 1m
- Module Overview 1m
- TABLESPACES Parameter 3m
- REMAP_TABLESPACE 1m
- Demo: TABLESPACES Parameter 7m
- Monitoring Oracle Data Pump Jobs 2m
- Attaching to a Job 2m
- Getting Job Information 1m
- Interactive Mode Commands 1m
- STOP_JOB 1m
- START_JOB 1m
- CONTINUE_CLIENT & STATUS 1m
- KILL_JOB & EXIT_CLIENT 1m
- PARALLEL 1m
- FILESIZE 1m
- ADD_FILE 1m
- Demo: Interactive Mode 7m
- Summary 1m
- Module Overview 1m
- Transporting Data 3m
- Full Transportable Export/Import 6m
- Database Transport Over Network 2m
- Transportable Tablespace Mode 1m
- Transportable Tablespace: Use Cases 1m
- Transportable Set 4m
- Steps for Transportable Tablespace Mode 1m
- Transportable Tablespaces: Limitations 1m
- Transportable Tables 1m
- Steps for Transportable Tables 2m
- Steps Using NETWORK_LINK 1m
- General Limitations While Transporting Data 2m
- Summary 1m
- Overview 2m
- Demo: Getting Started with Oracle Cloud 2m
- Demo: Creating Oracle Autonomous Database 3m
- Demo: Connecting to the Database and Setting It Up 4m
- Demo: Installing Oracle Instant Client 5m
- Demo: Exporting to Directory 3m
- Demo: Creating a Bucket for Oracle Object Store 2m
- Demo: Creating Credential Object 2m
- Demo: Moving Export Dump Files to Oracle Object Store 2m
- Demo: Exporting Directly to the Oracle Object Store 1m
- Demo: Importing to Oracle Autonomous Database from Dump Files in Oracle Object Store 2m
- Demo: Importing in Oracle Autonomous Database from Dump Files in Directory 2m
- Summary 1m
About the author
Pankaj Jain is an experienced technologist, with expertise in various aspects of software development lifecycle, architecting software solutions and software development. He has worked on an array of technologies, with focus on Oracle at the database layer and Java at the web tier. He is a certified Oracle 11g DBA. He lives in Seattle with his wife Simita and boys Ronit and Rohak. When he is not playing with technology, he likes spending time with his kids, travelling and doing photography.