Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2005
    Posts
    3

    Unanswered: 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 ?

    Thanks
    Last edited by longbeach75; 03-02-05 at 08:57.

  2. #2
    Join Date
    Oct 2003
    Location
    Jordan
    Posts
    28

    Talking

    Hi

    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.
    Firas arramli
    Systems Analyst

  3. #3
    Join Date
    Oct 2003
    Posts
    60
    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.
    jaraba

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •