Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2007
    Posts
    63

    Unanswered: Loading .dat file into sql developer

    what is the convenient way to load a .dat file into a table thru SQL developer? please help.
    I dont have sql loader.

    If I open the .dat file in excel and convert into .csv file and try importing the file, it would take atleast one hour to map the columns to the cols of data as the table holds 500 columns. Is there any other way? please suggest.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    >Is there any other way?
    no

    >the table holds 500 columns.
    It appears the data is not normalized

    >If I open the .dat file in excel
    Oracle is not able to open & utilize a "pure" Excel file
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

  3. #3
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Thumbs down

    . . . it would take at least one hour to map the columns . . .
    Better start mapping those columns right now.
    If the .dat file does not contain a header with the column names you will have to do the mapping anyway -- no matter what method you use to load the data. In fact how will you create the target table if you do not know the contents of that file?

    I dont have sql loader.
    Yes you do, it should come with the Oracle client (if not, then install Oracle client).
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

Posting Permissions

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