Re: import dmp into SQL Server

"John Bell" <jbellnewsposts_at_hotmail.com> wrote in message news:<41304103$0$25950$afc38c87_at_news.easynet.co.uk>...
> Hi
>
> Output files exported from Oracle using the Oracle Export utility may
> contain DDL as well as data, it will also probably contain multiple tables
> and other objects. If this is your situation then I suggest that you install
> Oracle onto a machine and then either create a linked server or export it in
> a different way.
>
> John
> "ccc31807" <ccc31807_at_hotmail.com> wrote in message
> news:22e055d5.0408270728.66a4987c_at_posting.google.com...
> > A newby question:
> >
> > I've got a .dmp from from an Oracle database that I need to import
> > into SQL Server. I have no idea how to do this.
> >
> > If anyone know how to do this, I'd very, very much appreciate the
> > help.
> >
> > Thanks, CC

You may want use third party tool like FastReader form WisdomForce (www.wisdomforce.com) to unload Oracle tables into ascii text file. FastReader also generates input for mssql loader. One quick step process Received on Sun Aug 29 2004 - 00:33:32 CEST