Skip to Main Content
Forums

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Howto update xmlns of whole document

Stanislav StudenýJul 21 2015 — edited Jul 24 2015

Hello.

Is there a way on 11.2.0.4/12.1.0.2 to simply update default namespace (xmlns) of whole XML document (about 450MB each) stored in table column of XMLType with no schema binding?

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


<ROOT xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="https://noname.com My_schema.xsd" xmlns="https://noname.com">


     <SUBTAGS>


     ..


     </SUBTAGS>


</ROOT>

Thanks for help.
This post has been answered by odie_63 on Jul 21 2015
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 21 2015
Added on Jul 21 2015
#performance-availability, #update, #xml, #xml-db
4 comments
1,048 views