3 Oracle Data Pump Import
With Oracle Data Pump Import, you can load an export dump file set into a target database, or load a target database directly from a source database with no intervening files.
- What Is Oracle Data Pump Import?
Oracle Data Pump Import is a utility for loading an Oracle export dump file set into a target system. - Starting Oracle Data Pump Import
Start the Oracle Data Pump Import utility by using theimpdp
command. - Filtering During Import Operations
Oracle Data Pump Import provides data and metadata filtering capability, which can help you limit the type of information that you import. - Parameters Available in Oracle Data Pump Import Command-Line Mode
Use Oracle Data Pump parameters for Import (impdp
) to manage your data imports. - Commands Available in Oracle Data Pump Import Interactive-Command Mode
In interactive-command mode, the current job continues running, but logging to the terminal is suspended, and the Import prompt (Import>
) is displayed. - Examples of Using Oracle Data Pump Import
You can use these common scenario examples to learn how you can use Oracle Data Pump Import to move your data. - Syntax Diagrams for Oracle Data Pump Import
You can use syntax diagrams to understand the valid SQL syntax for Oracle Data Pump Import.
Parent topic: Oracle Data Pump