Friday, March 9, 2012

how to import an Oracle 8.1.7 dump file into SQL server 2000 ?

Hi,
I do not know if it can be done:
how to import an Oracle dump file into SQL server ?
That dump file contains the content of a table, excported from Oracle.
Is there a way or another to import it to SQLServer 2000 ?
ThanksHi

I think it is better to use DTS packge or use the Import/Export Wizard, but directly from an Oracle dump file i don't think so.|||Oracle Dump files are written in binary that only Oracle understands. If the table is still in Oracle, you can try linking the Oracle schema to SQL and running a DTS to bring in the data.

No comments:

Post a Comment