Collections:
Import One Table back from a Dump File in Oracle
How To Import One Table Back from a Dump File in Oracle?
✍: FYIcenter.com
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.
⇒ Original Export/Import Utilities in Oracle
⇐ Error: Imported Table Already Exists in Oracle
2016-10-15, 2830🔥, 0💬
Popular Posts:
Can You Drop an Index Associated with a Unique or Primary Key Constraint in Oracle? You can not dele...
How To Install Oracle Database 10g XE in Oracle? To install 10g universal edition, double click, Ora...
How To Divide Query Output into Multiple Groups with the GROUP BY Clause in SQL Server? Sometimes, y...
How to set the current database in SQL Server? Once you are connected to the SQL Server, you should ...
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle ins...