Import from Oracle dump file

Hi,
I have an dump file for a oracle table with a ".dat" extension.
How can I import this into my SQL Server2000 db?
MandarI don't believe that it will be possible. I think that you will probably
have to restore the Oracle database and connect to that server via a linked
server or DTS and pull the data from the Oracle server.
--
Keith
"IB Ghost" <ibghost@.hotmail.com> wrote in message
news:uGzm049TFHA.2664@.TK2MSFTNGP15.phx.gbl...
> Hi,
> I have an dump file for a oracle table with a ".dat" extension.
> How can I import this into my SQL Server2000 db?
> Mandar
>|||Hi,
As Keith pointed out you can not load a Oracle dump file into sql server.
FYI, a dump (backup) file from any RDBMS can not be loaded into
a different RDBMS, this is due to variations in architecture. One way is to
load the dump file into Oracle server and use DTS or use SQLLDR utility from
Oracle to
generate the text output and use BCP IN or BULK INSERT in sql server to load
it into SQL Server.
You may need to convert the SQL/PLSQL . See the below link.
http://www.microsoft.com/resources/documentation/sql/2000/all/reskit/en-us/part2/c0761.mspx
Thanks
Hari
SQL Server MVP
"IB Ghost" <ibghost@.hotmail.com> wrote in message
news:uGzm049TFHA.2664@.TK2MSFTNGP15.phx.gbl...
> Hi,
> I have an dump file for a oracle table with a ".dat" extension.
> How can I import this into my SQL Server2000 db?
> Mandar
>