Oracle Database : Complete Export and Import

Suppose, we need to export all the Oracle schema in one step, similar
to "--all-databases" option in MySQL. In such cases, here is how its done:

exp USERID=system/password@sid file=complete_bak.dmp log=/tmp/full.log FULL=Y;

This should export all the databases in one step and will store that to a single file.

Now to import that back, here is what needs to be done.

imp system/password@sid file=complete_bak.dmp log=/tmp/full.log full=y ignore=y

Note:

* Will work only if ORACLE_HOME is same on both servers
* Create tablespace on the new server before importing the database. Else this wont work.