O'Reilly logo

OCA/OCP Oracle Database 11g All-in-One Exam Guide by Bob Bryla, Roopesh Ramklass, John Watson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

CHAPTER 23Moving and Reorganizing Data

Exam Objectives

In this chapter you will learn to

• 052.17.1 Describe and Use Methods to Move Data (Directory Objects, SQL*Loader, External Tables)

• 052.17.2 Explain the General Architecture of Oracle Data Pump

• 052.17.3 Use Data Pump Export and Import to Move Data Between Oracle Databases

• 053.16.2 Describe the Concepts of Transportable Tablespaces and Databases

• 053.16.1 Manage Resumable Space Allocation

• 053.16.3 Reclaim Wasted Space from Tables and Indexes by Using the Segment Shrink Functionality

There are many situations where bulk transfers of data into a database or between databases are necessary. Common cases include populating a data warehouse with data extracted from transaction processing ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required