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.
Course info
Level
Beginner
Updated
November 1, 2016
Duration
3h 29m
Table of contents
Overview
5m 29s
Description
Course info
Level
Beginner
Updated
November 1, 2016
Duration
3h 29m
Description

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.

About the author
About the author

Experienced technologist, with expertise in various aspects of software development lifecycle, architecting software solutions and software development.

More from the author
Getting Productive with SQL Developer
Beginner
3h 53m
20 Apr 2017
More courses by Pankaj Jain
Transcript
Transcript

Hello everyone, my name is Pankaj Jain and welcome to this course on Importing and Exporting Oracle Data for DBAs. Oracle database is a very popular and widely used database, used by organizations all around the world.

In this course we will explore the Oracle Data Pump tool, a very powerful and feature rich tool, whichprovides a very fine grained control to the Oracle DBAs in what they want to move, right from the entire database to just a table with specific rows.

Some of the major topics we will cover include:
1. Conceptually understanding how Oracle Data Pump works, its major components, features and performance benefits.
2. See how easy it is to create test copies of production schemas and consolidate schemas.

Sometimes we logically organize our objects in tablespaces and Oracle data pump allows us to easily move table spaces from one instance to another. We will take a good look at its various data and metadata filtering capabilities which can help usbe very specific in the objects and data rows we want to move. We will take a high level overview of the transporting data options which increase the performance of moving data significantly. We will talk about some of its useful features which can help reduce storage space requirements for dump files, increase security by data masking and encryption. We will also talk briefly about how it works with Oracle 12c multi tenant architecture.

By the end of this course, you should be able to perform most of the basic DBA tasks of creating test copies of schemas, moving the entire database to specific tablespaces and tables. Before beginning, all you will need to follow along is basic Oracle DBA skills and knowledge.

I invite you to join meon this exciting journey to learn Importing and Exporting Oracle Data for DBAs at Pluralsight.