Results 1 to 9 of 9
  1. #1
    Join Date
    Dec 2003
    Posts
    76

    Unanswered: Importing data from files.

    Hi,

    I have another question I would like to place.
    Imagine I have three files with data exported from an Informix database.
    - FILE_1 with data from TABLE_1
    - FILE_2 with data from TABLE_2
    - FILE_3 with data from TABLE_3
    If I manage to create both TABLE_1, TABLE_2, TABLE_3 first is it easy and simple to Import data in FILE_1, FILE_2 and FILE_3 to those tables?

    Do you recommend using any tool like TOAD or another?

    Thanks!

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    SQLLDR utility
    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
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    The answer might depend on export files format.

  4. #4
    Join Date
    Dec 2003
    Posts
    76
    @Littlefoot

    Imagine I use DBExport to export both data and schema from an Informix database.
    Does SQL Loader do the job nice and easy?
    Is there any way an tool like TOAD can be used to read those files to upload them to Oracle?

    Thanks!

  5. #5
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    You most probably know how files exported with DBExport look like. I don't, so - I have no idea whether SQL*Loader is capable of handling them or not. SQL*Loader enjoys in CSV files. It hates binary files.

    So, if you could post a few sample lines of your export files, it would be easier to answer.

  6. #6
    Join Date
    Dec 2003
    Posts
    76
    @Littlefoot

    I can only get you a sample of the export file, next week, but I would to ask you another thing.
    Does the next sentence solve my problem?
    "UNLOAD to flatfilename DELIMITER ',' SELECT * FROM TABLENAME"

    With the previous sentence I would manage to get the contents of an Informix table in CSV format, right? And therefore I would manage to open that file with SQL Loader, TOAD or any other tool, right?

    Thanks!

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

    Wink

    Quote Originally Posted by aucrun View Post
    @Littlefoot

    I can only get you a sample of the export file, next week, but I would to ask you another thing.
    Does the next sentence solve my problem?
    "UNLOAD to flatfilename DELIMITER ',' SELECT * FROM TABLENAME"

    With the previous sentence I would manage to get the contents of an Informix table in CSV format, right? And therefore I would manage to open that file with SQL Loader, TOAD or any other tool, right?

    Thanks!
    I recommend you use some other delimiter in case your text columns contain commas and are not enclosed in quotes.

    My2c.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  8. #8
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,509
    a nice delimiter that is not normally in data is a pipe |
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

  9. #9
    Join Date
    Feb 2006
    Posts
    173
    Provided Answers: 1
    You could also use an external table, Check out:
    Managing External Tables

    Or just google this subject for lots of info: Oracle external table

Posting Permissions

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