Advertisement

01.30.2008 at 05:28AM PST, ID: 23122598
[x]
Attachment Details

import one table from full export .dmp

Asked by agcsupport in Oracle Database, Oracle 9.x

Tags: Oracle, Oracle 9i Database, 9i

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.
Thanks.Start Free Trial
 
Keywords: import one table from full export .dmp
Title
1 How to view .DMP file
2 Oracle export to dmp
3 *.dmp files
4 Importing a dmp
5 Import dump file (.dmp)
6 Import dump file (.dmp)
 
Loading Advertisement...
 
[+][-]01.30.2008 at 05:33AM PST, ID: 20776803

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]01.30.2008 at 06:13AM PST, ID: 20777094

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: Oracle Database, Oracle 9.x
Tags: Oracle, Oracle 9i Database, 9i
Sign Up Now!
Solution Provided By: joebednarz
Participating Experts: 2
Solution Grade: A
 
 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628