1 2 Previous Next 15 Replies Latest reply: Apr 25, 2013 3:15 PM by mdrake-Oracle RSS

    XMLType default storage  change, BINARY XML to BASICFILE CLOB conversion

    755699
      Hello 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!
        1 2 Previous Next