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, 2230🔥, 0💬
Popular Posts:
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...
What Are the Underflow and Overflow Behaviors on FLOAT Literals in SQL Server Transact-SQL? If you e...
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...
How to download and install Microsoft .NET Framework Version 2.0 in SQL Server? .NET Framework Versi...