Showing posts with label donehow. Show all posts
Showing posts with label donehow. Show all posts

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.