DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2007

    Unhappy Import of XML files using SQL Loader


    We have an import script running on a Unix server, using SQL*Loader to import files with information into a database table in Oracle 9. Now we want to be able to import XML formatted files instead of "text" files. Can we still use SQL*Loader to do this or should we use a different tool.

    Can anyone give me a hint?



  2. #2
    Join Date
    Mar 2007
    Ft. Lauderdale, FL
    OracleŽ XML DB Developer's Guide
    10g Release 2 (10.2)
    Part Number B14259-02
    29 Loading XML Data Using SQL*Loader
    Pablo (Paul) Berzukov

    Author of Understanding Database Administration available at amazon and other bookstores.

    Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.

  3. #3
    Join Date
    Oct 2007
    We are using Oracle 9, should that be a difference?

    We don't want XML in the database, just normal number, varchar datatypes as they are today. What should the steps be to be able to use SQL*Loader importing the XML formatted files into a database table?

    Are there any good examples of this somewhere?


Posting Permissions

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

Click Here to Expand Forum to Full Width

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.