Dumping data to Oracle 10g via command line

Assuming you have already created the DB user, see http://blogs.exist.com/jcutaran/2008/02/18/creating-a-user-in-oracle-10g-through-command-line/

1. Log into a command console with the oracle user

> su - oracle

2. execute the command template below

imp userid= fromuser= toUser= file= log= compile=y commit=y

example:

> imp userid=system/password fromuser=NPN6 toUser=NPN6 file=~/version1.dmp log=~/imp.log compile=y commit=y

some notes:
userid - refers to the account with administrative rights
fromUser/toUser - refers to user account which the dump will be imported
file - refers to the dump file

—

again thanks to Ken D.

Posted on 02.18.08 to Oracle by Julz. Tagged dump, Oracle. Subscribe to follow comments on this post. No comments yet. Add your thoughts or trackback from your own site.