DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Import of XML files using SQL Loader

  1. #1
    Join Date
    Oct 2007
    Posts
    2

    Unhappy Import of XML files using SQL Loader

    Hi

    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?

    Regards

    sst

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,555
    Oracle® XML DB Developer's Guide
    10g Release 2 (10.2)
    Part Number B14259-02
    29 Loading XML Data Using SQL*Loader
    http://download-west.oracle.com/docs...9/xdb25loa.htm
    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
    Posts
    2
    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?

    SST

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