Pro Oracle Database 12c Administration by Darl Kuhn

Author:Darl Kuhn [Kuhn, Darl]
Language: eng
Format: epub
Tags: Computers, General, Databases, System Administration
ISBN: 9781430257288
Publisher: Apress
Published: 2013-07-24T04:00:00+00:00

Importing a Table

One of the key reasons to export data is so that you can recreate database objects. You may want to do this as part of a backup strategy or to replicate data to a different database. Data Pump import uses an export dump file as its input and recreates database objects contained in the export file. The procedure for importing is similar to exporting:

Create a database directory object that points to an OS directory that you want to read/write Data Pump files from.

Grant read and write privileges on the directory object to the database user running the export or import.

From the OS prompt, run the impdp command.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.