How to import & export and create new user by using oracle database

1. create new user :

• sqlplus "/ as sysdba"
• create user kmportal identified by password;
• grant connect to kmportal;
• grant resource to kmportal;
• grant dba to kmportal;
• grant create any snapshot to kmportal;
• exit sqlplus

2. import database:

• sqlplus kmportal/password
• imp kmportal/password FILE="/usr/local/../../kmportal.dmp" FULL=y LOG="/../../kmportal.log"

3. export database:

• sqlplus kmportal/password
• exp kmportal/password FILE="/usr/local/../../kmportal.dmp"