AboutElliot Mak Expertise I can answer questions with regarding to Oracle DB (8i, 9i, 10g) installation, configuration, administration, Data Guard, SQL, and PL/SQL (Procedures, triggers, functions).
Experience I am an Oracle DBA, Senior PA, Project Manager, and Data Architect with 10 years of experience.
Question How can i import the oracle8i server dump? I want to upload the dump from windows directory (ie. c:\kum.dump) to database. could u pls send me the query or command for the above question.we r using Oracle8i server with Windows 2000 NT server(OS).
Answer Good day
In order for you to perform the importdo it using command line, in this case, MS-DOS command.
The import command is "IMP" which is located in your Oracle bin directory.
If you need more information, you can type "IMP -?" in the command line. Or you can use the interactive mode by typing "IMP" in the command line, it will step you thru the import process.
Hope it helps. If you shall have any questions, please don't hesitate to contact me.
