Skip to Main Content
  • Questions

  • What do I need to import Oracle dmp file from Oracle RAC into an offline standalone laptop? What application(s) is necessary?

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question, Denise.

Asked: January 26, 2018 - 1:18 am UTC

Last updated: January 26, 2018 - 3:45 pm UTC

Version: 11g and 12c

Viewed 1000+ times

You Asked

Aloha Tom,
I used to work with Oracle (years ago), I've been working on virtualization and SQL server from past 15 years, now I have a task at my new job that I cannot figure out what would be best and required for it.
They have exported Oracle RAC 11g schema to a dmp file and they asked me to load it to my work laptop offline from the production system.
What are the Oracle installation pieces that I need to import this dmp file and do I need to modify all listener, tsnames and etc accordingly with the system where the dmp comes from?

I am completely lost in how to load this dmp file which seems to be a very simple task, please advise very much appreciated.

Mahalos
Denise Beadle
denise.beadle@gmail.com

and Chris said...

The file will have come from an export, probably "new style" data pump. But possibly plain old export. It will include users and their objects; tables, views, procedures, etc. What exactly is in it depends on what the DBAs exported!

All you need to import it is your own database. No changes to the listener, tnsnames, etc. needed.

Read all about it at:

https://docs.oracle.com/en/database/oracle/oracle-database/12.2/sutil/datapump-import-utility.html#GUID-D11E340E-14C6-43B8-AB09-6335F0C1F71B

Is this answer out of date? If it is, please let us know via a Comment
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's channel and Chris's channel from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

Data Pump

All of the database utilities including Data Pump are explained in the Utilities guide.