• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 5172
  • Last Modified:

import one table from full export .dmp

I have a full export from .dmp file of my database.  I just found out that a table that needs to be in the database is no longer there.  I would like to know two things.  First I would like to know how to get a list of the tables in a dump file and secod the command i would use to import just one table from the full export dmp file I have.
1 Solution
Guy Hengel [angelIII / a3]Billing EngineerCommented:
faq: http://www.orafaq.com/faqiexp.htm
q2: imp ....  tables=dept
IMP help=Y

This will show you all the options...

1) imp file=yourfile.dmp show=Y
2) imp file=yourfile.dmp fromuser=owner touser=new_owner tables=one_table;

I think for the second one, you can do this:

imp file=yourfile.dmp tables=owner.one_table;
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now