Re: Importing .dmp file in Windows

"Matthew J. McNally" wrote:

> I know this is probably a common question - I have found several threads
> searching google, but none of them have fixed my problem.
>
> 8(
>
> I have been given a .dmp file from a client, which I know is an export of an
> Oracle database.
>
> But - I cannot import it into a database.
>
> I am really struggling at doing this - I have spent a lot of time searching
> google - but find only answers to questions, other than my own.
>
> What I am really looking for is a very basic, step by step guide to creating
> importing data from the .dmp file into a new database.
>
> I really son't want to do anything with it in Oracle - just need it in a
> database so I can use ODBC to import it into a SQL Server database (as the
> client is an MS shop).
>
> Any help or pointers for someone having a hard time?
>
> Matt

There is an executable on the Oracle server in the bin directory named IMP (UNIX) or IMP.EXE (Windows).

That is the executable used to import .dmp files created by EXP and it will only import them into an Oracle database. To learn about this go to http://tahiti.oracle.com and search under 'IMP' and 'IMPORT'.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)