Importing dump file to Oracle ~ OracleSource

Monday, August 4, 2008

Importing dump file to Oracle

You can import a emp.dmp file to Oracle using the below command line syntax.

C:\>imp userid/password@ora10 file=emp.dmp tables=test fromuser=lispadmin touser=lisp

If Oracle is installed on C drive use c:\
tables = test tells the case when one want to exclusively import only some tables.

No comments: