Printable View
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
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
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