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