When you enroll through our links, we may earn a small commission—at no extra cost to you. This helps keep our platform free and inspires us to add more value.

Data Science
pluralsight logo

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.

     
  • 4
    •  |
  • Reviews ( 21 )
Free
Importing and Exporting Oracle Data for DBAs

Related Courses

This Course Includes

  • iconpluralsight
  • icon4 (21 reviews )
  • icon4 hour 4 minutes
  • iconenglish
  • iconOnline - Self Paced
  • iconExpanded Courses
  • iconpluralsight

About Importing and Exporting Oracle Data for DBAs

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.

What You Will Learn?

  • Course Overview : 2mins.
  • Overview : 7mins.
  • Understanding Oracle Data Pump : 34mins.
  • Moving Schemas & Metadata : 51mins.
  • Moving Specific Tablespaces, Suspending, Resuming, and Monitoring Jobs : 34mins.
  • Moving Specific Objects and Filtering Data : 30mins.
  • Moving Databases & Transportable Tablespaces : 28mins.
  • Configuring Advanced Import and Export Parameters : 16mins.
  • Working with Oracle Multitenant Architecture : 6mins.
  • Working with Oracle Autonomous Database in the Cloud : 30mins.