December 9, 2009

Oracle Data Import / Export command (imp, exp) samples

Filed under: Database,Linux,Oracle,Software Development — mariojump @ 2:59 pm
Tags: , , , ,

There are occasions we need to export or import data from/to Oracle.

These are sample command line inputs to do so.  The database can be local (localhost, or remote server.

$ exp db_username1/password_of_username1@ TABLES=(db_username1.%) FILE=exportfile1.dat exportfile2.dat exportfile3.dat exportfile4.dat FILESIZE=1024MB INDEXES=n LOG=logfile.log

$ imp system/password_of_system@ FROMUSER=(db_username) TOUSER=(maybe_another_db_username) FILE=./exportfile1.dat INDEXES=n GRANTS=y STATISTICS=RECALCULATE LOG=importlog.log


Leave a Comment »

No comments yet.

RSS feed for comments on this post. TrackBack URI

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Create a free website or blog at

%d bloggers like this: