Oracle import dmp file

In this tutorial, How to using Oracle import dmp file.

  1. Create new schema
  2. Oracle import dmp file for new schema

Create new schema

cd /tmp
sqlplus "/as sysdba"
SQL> @/home/oracle11g/HuuPV2/CRT_SCHEMA_newhuupv
exit;

How to create new schema file CRT_SCHEMA_newhuupv

Oracle import dmp file

export NLS_LANG=American_America.UTF8
imp userid=oldhuupv/oldhuupv@DevopsRoles fromuser=oldhuupv touser=newhuupv BUFFER=100000 file=./exp_ora.dmp log=./exp_ora.log

Note:

  • File dump: exp_ora.dmp
  • Service Name: DevopsRoles
  • To schema: newhuupv

Conclusion

Thought the article, you can use Oracle import dmp file as above. I hope will this your helpful.

About HuuPV

My name is Huu. I love technology and especially Devops Skill such as Docker, vagrant, git so forth. I likes open-sources. so I created DevopsRoles.com site to share the knowledge that I have learned. My Job: IT system administrator. Hobbies: summoners war game, gossip.
View all posts by HuuPV →

Leave a Reply

Your email address will not be published. Required fields are marked *

Comment moderation is enabled. Your comment may take some time to appear.

This site uses Akismet to reduce spam. Learn how your comment data is processed.