Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How To Import One Table Back from a Dump File
How To Import One Table Back from a Dump File? - Oracle DBA FAQ - Loading and Exporting Data
✍: 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.
2007-05-02, 5136👍, 0💬
Popular Posts:
Advantages of a macro over a function? Macro gets to see the Compilation environment, so it can expa...
How To Delete All Rows a Table? - MySQL FAQs - Understanding SQL INSERT, UPDATE and DELETE Statement...
interview.FYIcenter.com offers a collections of interview questions and answers for software and Web...
What is cross page posting? By default, button controls in ASP.NET pages post back to the same page ...
How To Delete a User Account? - Oracle DBA FAQ - Managing Oracle User Accounts, Schema and Privilege...