【DM版本】:8.1
【操作系统】：centos7
【CPU】:intel x86
【问题描述】*：物化视图不支持[ARR$_0000000000B842D0]的对象类型

create materialized view "SYSDBA"."XML_TABLE2_MV"
/*视图的列名, 格式为(<列名>{, <列名>}),此处为可选*/
storage(initial 1, next 1, minextents 1, fillfactor 0)
refresh on commit with primary key force 
as
-- 解析 XML
SELECT 
    A.id,
    VT.videoNo,
    VT.videoName,
    VT.videoFile,
    VT.videoSize,
    VT.videoMd5
FROM 
    xml_table2 AS A
CROSS JOIN XMLTABLE(
    '/request/videos/video'
    PASSING A.xml_content
    COLUMNS
        videoNo VARCHAR(10) PATH 'videoNo',
        videoName VARCHAR(255) PATH 'videoName',
        videoFile VARCHAR(255) PATH 'videoFile',
        videoSize VARCHAR(255) PATH 'videoSize',
        videoMd5 VARCHAR(32) PATH 'videoMd5'
) VT 
WHERE A.xml_content IS NOT NULL AND TRIM(A.xml_content) <> '';

XML文件格式：

<request>
 <videos>
      <video>
          <videoNo>1</videoNo>
          <videoCode> </videoCode>       
          <videoName>XXX名称</videoName>
          <videoFile>(1).mp4</videoFile>
          <videoSize>1693030</videoSize>			
          <videoMd5></videoMd5>
      </video>
      <video>
          <videoNo>2</videoNo>
          <videoCode> </videoCode>
          <videoName>XXX名称</videoName>
          <videoFile>(2).mp4</videoFile>
          <videoSize>12995445</videoSize>
          <videoMd5></videoMd5>
      </video>
  </videos>
</request>