Import One Table back from a Dump File in Oracle

Q

How To Import One Table Back from a Dump File in Oracle?

✍: FYIcenter.com

A

If you only want to import one table back to the database, you can use a dump file that was created by full export, schema export or a table export. The following tutorial exercise shows you how to import the "fyi_links" table from a dump file created by a schema export:

>cd \oraclexe\app\oracle\product\10.2.0\server\BIN

>sqlplus /nolog
SQL> connect HR/fyicenter

SQL> DROP TABLE fyi_links;
Table dropped.

SQL> exit;

>impdp hr/fyicenter TABLES=fyi_links DIRECTORY=hr_dump
  DUMPFILE=schema.dmp LOGFILE=tables.log

Master table "HR"."SYS_IMPORT_TABLE_01" loaded/unloaded
Starting "HR"."SYS_IMPORT_TABLE_01":  hr/** TABLES=fyi_links
  DIRECTORY=hr_dump DUMPFILE=schema.dmp LOGFILE=tables.log
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
. . imported "HR"."FYI_LINKS"             6.375 KB    4 rows
Processing object type SCHEMA_EXPORT/TABLE/CONSTRAINT/CON...
Processing object type SCHEMA_EXPORT/TABLE/INDEX/STATISTI...
Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TAB...
Job "HR"."SYS_IMPORT_TABLE_01" successfully completed.

 

Loading and Exporting Data in Oracle

⇒⇒Oracle Database Tutorials

2016-10-15, 581👍, 0💬