By arunraj
1. Log-on to server where Oracle is installed, go to $ORACLE_HOME/bin/
Export schema oracle_db/oracle_db from orcl using the following command,
2. Go to /tmp/ folder and check oracleDBExpor.dmp file is available.
3. Log-on to server where schema is to be imported, go to $ORACLE_HOME/bin/
Execute the following command
imp userid=oracle_db/oracle_db@orcl file=<file location WHERE the exported *.dmp file IS available> ROWS=n IGNORE=y fromuser= oracle_db touser=oracle_db
4. Log-in to SQL Plus or any Oracle client using the above imported schema name and check whether all the db objects are created successfully.
Technology: