Re: Restoring a DMP file...

From: Bert Bear <bertbear_at_NOSPAMbertbear.net>
Date: Tue, 24 Dec 2002 00:45:37 GMT
Message-ID: <R6ON9.145$IA1.116367510@newssvr11.news.prodigy.com>

Rich,

First I would suggest getting an idea of what is within the DMP file or files. I usually do this via the command:

imp userid=System/System Password_at_SID show=y full=y file="<filename.dmp>" grants=no log="<filename.log>"

I use the .dmp and .log to help me determine what the person put into the export.

The output file will show you all the DDL and data to recreate the username. You use this information to build the import command for the actual schema/username recreation.

To get help on the command do: imp help=y

Bertram Moshier
Oracle Certified Professional 8i and 9i DBA

http://www.bmoshier.net/bertram

"RichTrawinski" <member_at_dbforums.com> wrote in message news:2313318.1040670681_at_dbforums.com...
>
> Hi, I've been handed these DMP file I need to run reports against. I am
> told they are a complete dump of a database. How do I restore the DB
> from the DMP file? Thanks
>
> --
> Posted via http://dbforums.com
Received on Mon Dec 23 2002 - 18:45:37 CST