Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2003
    Posts
    81

    Unanswered: Import XML-tables in Oracle

    I have got 10 XML-tables with additional 10 XSD-files. I want to import these tables into Oracle. How do I do this as easy as possible? My Oracle version is 9.2.0.1

  2. #2
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    Can you be more specific what a "XML table" is?
    Is that data exported (from some other DBMS) in XML format?

  3. #3
    Join Date
    Jun 2003
    Posts
    81
    Yes. Data is from an existing table. XML is used for data exchange.

    EX:

    <?xml version="1.0" encoding="iso-8859-1" standalone="no" ?>
    - <KMD_XT90000T_KommunenummerdelingKonvTabel xmlns:msdata="urn:schemas-microsoft-com:xml-msdata" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="XT90000T_Kommunenum merdelingKonvTabel.xsd">
    - <XT90000T_KommunenummerdelingKonvTabel>
    <GL_KOMMUNENUMMER>233</GL_KOMMUNENUMMER>
    <GL_FIKT_KOMMUNENR>224</GL_FIKT_KOMMUNENR>
    <GL_FIKT_IDENT />
    <GL_FIKT_BESKR />
    <NY_KOMMUNENUMMER>219</NY_KOMMUNENUMMER>
    </XT90000T_KommunenummerdelingKonvTabel>
    ....

  4. #4
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    I don't know of any Oracle tool that would be able to import that.

    This seems to be created with some Microsoft Tool.
    Maybe that tool can import the XML file into an Oracle database?

    Edit: there seems to be an Oracle tool that can do that: XSU

    http://www.oracle.com/technology/tec...userguide.html
    Last edited by shammat; 01-02-07 at 10:27.

Posting Permissions

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