Expanded

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
Rating
(16)
Level
Beginner
Updated
Aug 25, 2021
Duration
4h 3m
Table of contents
Course Overview
Overview
Understanding Oracle Data Pump
Moving Schemas & Metadata
Moving Specific Tablespaces, Suspending, Resuming, and Monitoring Jobs
Moving Specific Objects and Filtering Data
Moving Databases & Transportable Tablespaces
Configuring Advanced Import and Export Parameters
Working with Oracle Multitenant Architecture
Working with Oracle Autonomous Database in the Cloud
Description
Course info
Rating
(16)
Level
Beginner
Updated
Aug 25, 2021
Duration
4h 3m
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
Oracle REST Data Services
Beginner
5h 30m
Feb 13, 2018
More courses by Pankaj Jain
Section Introduction Transcripts
Section Introduction Transcripts

Course Overview
[Autogenerated] Hello everyone. My name is Panca chain and welcome to this course on importing and exporting oracle data for dBS. Oracle database is a very popular and widely used database used by organizations all around the world. In this course we will explore the Oregon. Did a pontoon a very powerful and feature rich tool which provides a very fine grain control to the organ dBS in what they want to move right from the entire database to just a table with specific growth. Some of the major topics will cover include conceptually understanding how oracle data pump works, its major components features and performance benefits, how to export and import data with cloud databases. You will see how easy it is to create test copies of production schemas and consolidate schemas. Sometimes we logically organize our objects and table spaces and oracle data. POM 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 us be really specific in the objects and data rows We want to move we will take a high level overview of the transporting data options which increases the performance of moving data significantly. We will talk about some of its useful features which can help reduce storage space requirements for dumb files, increase security by data masking an encryption. We will also talk briefly about how it works with the oracles multi tenant architecture. We will create an oracle autonomous database in the cloud and see how to export data out of it as well as import data into it By the end of the scores, you should be able to perform most of the basic deviate tasks of creating test copies of schemas, moving the entire database to specific table spaces and tables all you need to follow along our basic article Devious Skills and Knowledge. I invite you to join me on this exciting journey to learn importing and exporting oracle data for DBS at Pluralsight