Re: How to import .dmp file to MS SQL Server 2000?

As others have said, the easiest way to get this is to download the free Oracle software and create a temp database that you can import the dmp file into. Then, extract from the temp database what you need using whatever tool you like.

There is also an easy way to get the data model from a dmp file without Oracle software. I am not sure it is possible on Windows, but in Unix, you could do a strings command on the dmp and pipe the output to a file that you could then edit out the create table statements , create index statements, etc .

In Unix, the command is:

strings your-name.dmp > your-name.txt

... just 1 example of the many reasons Unix is a much more productive environment than Windows ... :)

"Jay" <jay711685_at_yahoo.com> wrote in message news:3eea9771.0205221657.5db4d002_at_posting.google.com...
> Frank <fbortel_at_home.nl> wrote in message
 news:<3CEBDEF8.9020300_at_home.nl>...
> > Wrong ng - this is Oracle ng, not SQL Server, MySQL, Progres, TXT
> > If it is an Oracle export - you can read it into Oracle.
> >
 

> > Start installing Oracle (check with client for version!), then
> > take it from there.
> >
> > Frank
>
>
> Thank you for the reply the dmp file is an Oracle database. The
> client and I don't have Oracle software. He also doesn't know what
> version because he outsourcing someone to keep the data, and that guy
> is disappeared now. Any chance to get the data back?
Received on Sat May 25 2002 - 21:12:52 CEST