From the course: Oracle Database 12c: Backup and Recovery

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Exporting data using Data Pump

Exporting data using Data Pump - Oracle Database Tutorial

From the course: Oracle Database 12c: Backup and Recovery

Start my 1-month free trial

Exporting data using Data Pump

“

- [Instructor] Exporting data from your Oracle database using data pump is very easy and very straightforward. It's accomplished by using the expdp, command line utility. Expdp stands for export data pump. Let's see a quick example by exporting an entire Oracle schema. Entire meaning all of it's tables, indexes, views procedures and so on. To do that, we will tie expdp, using the expdp utility. Specify username and password, that has permissions to perform the export. In our case it's system and a password of oracle. Remember that this can change in your own environment. We'll also need to specify, which schemas we want to export. We do that by using the schemas parameter. So schemas= and a list of one or more schemas. Let's stick with one schema for our first example. So let's choose to export the Scott, schema. This will instruct Oracle data pump to export the Scott schema, only the Scott schema and all of the data and objects contained within it. Remember, that the Oracle export…

Contents