This discussion is archived
1 Reply Latest reply: Jul 30, 2012 1:16 AM by odie_63 RSS

Newbie for load XML to oracle11g

845611 Newbie
Currently Being Moderated
I'm a newbie for developer.
Can anyone tell me? Can i load this xml file to oracle11g?
Can i use sql loader? Or i should convert to other format first?

the example of xml as below:

<?xml version="1.0" encoding="UTF-8"?>

<!DOCTYPE mdc SYSTEM "MeasDataCollection.dtd">
-<mdc> -<mfh> <cbt>201207160500</cbt> </mfh> -<md> -<mi> <mts>201207160500</mts> <gp>60</gp> <mt>Average packet throughput in packets/s</mt> <mt>Downlink data forward success ratio</mt> <mt>Downlink dropped data packets with vip mamagement enabled</mt> <mt>Downlink ip address switch traffic in KB</mt> <mt>Downlink ip address switch traffic in MB</mt> <mt>Downlink ip address switch traffic in packets</mt> <mt>Dropped data packets of background class</mt> <mt>Dropped data packets of conversational class</mt> <mt>Dropped data packets of interactive class</mt> <mt>Dropped data packets of streaming class</mt> <mt>Dropped downlink packets with bwm</mt> <mt>Dropped downlink traffic in KB with bwm</mt> <mt>Dropped uplink packets with bwm</mt> <mt>Dropped uplink traffic in KB with bwm</mt> <mt>GGSN traffic in packets</mt> <mt>Gi downlink average throughput in MB/s</mt> <mt>Gi downlink average throughput in packets/s</mt> <mt>Gi downlink error L2TP packets</mt> <mt>Gi downlink L2TP packets</mt> <mt>Gi downlink L2TP packet in MB</mt> <mt>Gi downlink peak throughput in KB/s</mt> <mt>Gi downlink peak throughput in MB/s</mt> <mt>Gi downlink peak throughput in packets/s</mt> <mt>Gi downlink traffic in KB</mt> <mt>Gi downlink traffic in MB</mt> <mt>Gi downlink traffic in packets</mt> <mt>Gi IP data packets discarded for error</mt> <mt>Gi peak throughput in KB/s</mt> <mt>Gi peak throughput in MB/s</mt> <mt>Gi peak throughput in packets/s</mt> <mt>Gi traffic in KB</mt> <mt>Gi traffic in MB</mt> <mt>Gi traffic in packets</mt> <mt>Gi uplink average throughput in MB/s</mt> <mt>Gi uplink average throughput in packets/s</mt> <mt>Gi uplink L2TP packets</mt> <mt>Gi uplink L2TP packet in MB</mt> <mt>Gi uplink peak throughput in KB/s</mt> <mt>Gi uplink peak throughput in MB/s</mt> <mt>Gi uplink peak throughput in packets/s</mt> <mt>Gi uplink traffic in KB</mt> <mt>Gi uplink traffic in MB</mt> <mt>Gi uplink traffic in packets</mt> <mt>Gn downlink average throughput in MB/s</mt> <mt>Gn downlink average throughput in packets/s</mt> <mt>Gn downlink peak throughput in KB/s</mt> <mt>Gn downlink peak throughput in MB/s</mt> <mt>Gn downlink peak throughput in packets/s</mt> <mt>Gn downlink PPP packets</mt> <mt>Gn downlink PPP packet in MB</mt> <mt>Gn downlink traffic in KB</mt> <mt>Gn downlink traffic in MB</mt> <mt>Gn downlink traffic in packets</mt> <mt>Gn peak throughput in KB/s</mt> <mt>Gn peak throughput in MB/s</mt> <mt>Gn peak throughput in packets/s</mt> <mt>Gn traffic in KB</mt> <mt>Gn traffic in MB</mt> <mt>Gn traffic in packets</mt> <mt>Gn uplink average throughput in MB/s</mt> <mt>Gn uplink average throughput in packets/s</mt> <mt>Gn uplink error PPP packets</mt> <mt>Gn uplink peak throughput in KB/s</mt> <mt>Gn uplink peak throughput in MB/s</mt> <mt>Gn uplink peak throughput in packets/s</mt> <mt>Gn uplink PPP packets</mt> <mt>Gn uplink PPP packet in MB</mt> <mt>Gn uplink traffic in KB</mt> <mt>Gn uplink traffic in MB</mt> <mt>Gn uplink traffic in packets</mt> <mt>IPv6 Gi downlink peak throughput</mt> <mt>IPv6 Gi downlink peak throughput in packets/s</mt> <mt>IPv6 Gi downlink traffic</mt> <mt>IPv6 Gi downlink traffic in packets</mt> <mt>IPv6 Gi uplink peak throughput</mt> <mt>IPv6 Gi uplink peak throughput in packets/s</mt> <mt>IPv6 Gi uplink traffic</mt> <mt>IPv6 Gi uplink traffic in packets</mt> <mt>IPv6 Gn downlink peak throughput</mt> <mt>IPv6 Gn downlink peak throughput in packets/s</mt> <mt>IPv6 Gn downlink traffic</mt> <mt>IPv6 Gn downlink traffic in packets</mt> <mt>IPv6 Gn uplink peak throughput</mt> <mt>IPv6 Gn uplink peak throughput in packets/s</mt> <mt>IPv6 Gn uplink traffic</mt> <mt>IPv6 Gn uplink traffic in packets</mt> <mt>Number of packets with quintuple nodes exhausted</mt> <mt>One Tunnel downlink traffic in KB</mt> <mt>One Tunnel uplink traffic in KB</mt> <mt>Packets larger than 1500 bytes</mt> <mt>Peak packet throughput in packets/s</mt> <mt>Received gtp ip fragment flows</mt> <mt>Received ip fragment packets</mt> <mt>Received user ip fragment flows</mt> <mt>Successful reassemblies ip fragment packets</mt> <mt>Unexpected G-PDU messages</mt> <mt>Uplink data forward success ratio</mt> <mt>Uplink dropped data packets with vip mamagement enabled</mt> <mt>Uplink ip address switch traffic in KB</mt> <mt>Uplink ip address switch traffic in MB</mt> <mt>Uplink ip address switch traffic in packets</mt> -<mv> <moid>BFKT PBIHGG301/GGSN Function:BFKT PBIHGG301</moid> <r>883653</r> <r>99</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>453</r> <r>0</r> <r>1.64459e+06</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>3.18115e+09</r> <r>267</r> <r>256384</r> <r>0</r> <r>0</r> <r>0</r> <r>319197</r> <r>319</r> <r>300204</r> <r>9.61367e+08</r> <r>961369</r> <r>9.22983e+08</r> <r>1</r> <r>350403</r> <r>350</r> <r>517625</r> <r>1.06481e+09</r> <r>1.06481e+06</r> <r>1.58823e+09</r> <r>28</r> <r>184789</r> <r>0</r> <r>0</r> <r>34101</r> <r>34</r> <r>217184</r> <r>1.03443e+08</r> <r>103441</r> <r>6.65244e+08</r> <r>267</r> <r>256294</r> <r>319144</r> <r>319</r> <r>300114</r> <r>0</r> <r>0</r> <r>9.61262e+08</r> <r>961262</r> <r>9.22661e+08</r> <r>350585</r> <r>350</r> <r>518934</r> <r>1.06547e+09</r> <r>1.06547e+06</r> <r>1.59293e+09</r> <r>28</r> <r>186184</r> <r>0</r> <r>34310</r> <r>34</r> <r>218581</r> <r>0</r> <r>0</r> <r>1.04211e+08</r> <r>104212</r> <r>6.70265e+08</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>3.35844e+06</r> <r>0</r> <r>0</r> <r>0</r> <r>1.03656e+06</r> <r>7.71771e+06</r> <r>1.54354e+07</r> <r>3.15137e+06</r> <r>1.54354e+07</r> <r>760</r> <r>99</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <sf>false</sf> </mv> -<mv> <moid>BFKT MTGHGGSN01_NEW/GGSN Function:BFKT MTGHGGSN01_NEW</moid> <r>0</r> <r>100</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>12</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>3</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>6</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>3</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>3</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>6</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>3</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <r>100</r> <r>0</r> <r>0</r> <r>0</r> <r>0</r> <sf>false</sf> </mv> </mi> </md> -<mff> <ts>201207160600</ts> </mff> </mdc>
  • 1. Re: Newbie for load XML to oracle11g
    odie_63 Guru
    Currently Being Moderated
    What do you want to load, into what structure?

    Do you want to insert the data into a (or several) relational table(s)? Or do you want to insert the whole XML document into a database column?

    Give us more details, and the exact database version ("11g" is merely a product name, not a version).

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points