XMLType default storage change, BINARY XML to BASICFILE CLOB conversion
755699Mar 24 2011 — edited Apr 25 2013Hello guys!
I'm not familiar with XML, but need to perform rapidly following task:
I support 11.2.0.2 database with xml data. Vendor is asking to do following:
default storage model has changed
1. Change the default storage model for XMLType from BINARY XML (which is default for 11.2.0.2) to BASICFILE CLOB.
2. Convert all the tables' fields that has been created as BINARY XML to BASICFILE CLOB.
in regards to point 2 - I guess that the best way will be to export tables using expdp, generate sqlfile by impdp from dump, drop tables and create them with BASICFILE CLOB fields using sqlfile content, and import data with parameter CONTENT=DATA_ONLY. Am I right?
in regards to point 1 - I have no any idea and have not found any solution :(
thank you in advance for any advices!