IMPDP TABLE

Function

IMPDP TABLE specifies the execution phase of importing a table.

Syntax

IMPDP TABLE [AS table_name] SOURCE = 'directory' OWNER = user;

Parameter Description

• table_name: name of the new table after the import. If this parameter is not specified, the original table name is retained after the import.
• directory: data source directory of the imported table.
• user: owner of the imported table.

Example

impdp table source = '/data1/impdp/table0' owner=admin;