Export:
[root@localhost ~]# su oracle
[oracle@localhost root]$ exp loanadmin/123456@orcl file=/home/oracle/160926.dmp
loanadmin is the username, 123456 is the database password, orcl is the instance name (default is orcl), and file= specifies the destination path and filename for the dump.
Note: The /home/oracle/ directory must be writable by the oracle user, otherwise an error will occur.
Import:
[root@localhost ~]# su oracle
[oracle@localhost root]$ imp loanadmin/123456@orcl file=/home/oracle/160926.dmp full=y ignore=y
