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.

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.