oracle schema export / import

To export single schema, use following command.

exp username/password FILE=dump.dmp OWNER=username

imp username/password FROMUSER=user1 TOUSER=user2 FILE=dump.dmp

In some cases, exp/imp must be running as SYSDBA, in this case, enclose username into single quotes with backslashes.

imp \'sys/***** as sysdba\' FROMUSER=user1 TOUSER=user2 FILE=dump.dmp