Results 1 to 3 of 3

Thread: Import text file to Oracle

  1. 01-07-2004, 09:58 AM #1
    theresatan
    theresatan is offline Registered User
    Join Date
    Nov 2002
    Location
    Chicago
    Posts
    39

    Import text file to Oracle

    Hi,

    I have 5 small tables with about 3000 records in SQL server, and I want to convert them to oracle, but I don't want to use Oracle Migration Workbench.

    I want export those 5 sql tables to 5 text files. Does any tool can import text file to oracle?

    Thanks in advance!

    Theresa
    Reply With Quote Reply With Quote
  2. 01-07-2004, 10:44 AM #2
    MAK's Avatar
    MAK
    MAK is offline Registered User
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    1. From sql server you can directly export to oracle -DTS Package

    2. ETL tools like Informatica can do that.
    Reply With Quote Reply With Quote
  3. 01-08-2004, 11:41 AM #3
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Oracle has its own tool called SQL Loader, which does exactly what you are trying to do.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules