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, 2227🔥, 0💬
Popular Posts:
How To Turn on mysql Extension on the PHP Engine in MySQL? The "mysql" API extension is provided as ...
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...
What Is a Parameter File in Oracle? A parameter file is a file that contains a list of initializatio...
What Is an Oracle Tablespace in Oracle? An Oracle tablespace is a big unit of logical storage in an ...
Can Date and Time Values Be Converted into Integers in SQL Server Transact-SQL? Can date and time va...