Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2003
    Posts
    2

    Question Unanswered: loading into views

    I'm mapping data from multiple exisitng databases into an Oracle instance. I've setup a view that "looks like" the old data and have created an INSTEAD OF trigger to correctly insert the cols into the appropriate Oracle tables.

    The question is - what's the best method for importing the data? SQL*Loader appears to only work with Tables and not Views. I'm considering UTL_FILE, but if anyone else has a better suggestion, please let me know!

  2. #2
    Join Date
    Jan 2003
    Posts
    10
    Hi,

    if you are using 9i you can use a EXTERNAL TABLE instead of the sqlloader. The you have to select from the EXTERNAL TABLE and insert into the VIEW.

    In 8i you can load the data into a staging table with the sqlloader and the do an insert into ... select ....

    You can load one flatfile-record into multible database-tables with the sqlloader. Maby this is an option to load the data without using the VIEW and instead-of-trigger. Using the sqlloader in this way is match faster then using instead-of-triggers.

    Regards
    JF

  3. #3
    Join Date
    Mar 2003
    Posts
    2

    Thumbs up

    Hey - thanks!! You've given me some good ideas!

    Originally posted by jf_dba
    Hi,

    if you are using 9i you can use a EXTERNAL TABLE instead of the sqlloader. The you have to select from the EXTERNAL TABLE and insert into the VIEW.

    In 8i you can load the data into a staging table with the sqlloader and the do an insert into ... select ....

    You can load one flatfile-record into multible database-tables with the sqlloader. Maby this is an option to load the data without using the VIEW and instead-of-trigger. Using the sqlloader in this way is match faster then using instead-of-triggers.

    Regards
    JF

Posting Permissions

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