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?
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.
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?
Click Here to Expand Forum to Full Width