Home >> FAQs/Tutorials >> Oracle Tutorials
Oracle Tutorials - Import One Table back from a Dump File
By: FYIcenter.com
(Continued from previous topic...)
How To Import One Table Back from a Dump File?
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.
(Continued on next topic...)
- What Is the Simplest Tool to Run Commands on Oracle Servers?
- What Is the Quickest Way to Export a Table to a Flat File?
- How To Export Data with a Field Delimiter?
- What Is SQL*Loader?
- What Is a SQL*Loader Control File?
- How To Load Data with SQL*Loader?
- What Is an External Table?
- How To Load Data through External Tables?
- What Are the Restrictions on External Table Columns?
- What Is a Directory Object?
- How To Define an External Table in a Text File?
- How To Run Queries on External Tables?
- How To Load Data from External Tables to Regular Tables?
- What Is the Data Pump Export Utility?
- What Is the Data Pump Import Utility?
- How To Invoke the Data Pump Export Utility?
- How To Invoke the Data Pump Import Utility?
- What Are Data Pump Export and Import Modes?
- How To Estimate Disk Space Needed for an Export Job?
- How To Do a Full Database Export?
- Where Is the Export Dump File Located?
- How To Export Your Own Schema?
- How To Export Several Tables Together?
- What Happens If the Imported Table Already Exists?
- How To Import One Table Back from a Dump File?
- What Are the Original Export and Import Utilities?
- How To Invoke Original Export/Import Utilities?
|