创建物化视图时出现ORA-7445错误

刘泽宇

根据官方文档（ID:2267661.1）
在oracle12.1.0.2及之后版本上创建物化视图时可能会出现报错：
ORA 7445 [qsme_pls_string] during create mview with XML type functions.

STACK

skdstdst <- ksedst <- dbkedDefDump <- ksedmp <- ssexhd
<- sslsshandler <- sighandler <- qsme_pls_string <- qsme_expr_string
<- 1338
<- qsme_expr_string <- 1563 <- qsme_opn_to_text <-
qsmkzik_init_qsmksk <- qsmkzcc_correlate_s
<- um_cols <- qsmkzss_sum_setup_q <- qsmkzss_setup_summa <-
qsmkzsm_summary_sem <- antics_and_metadata
<- kkmpqaq <- kkmpqcbk <- qcspqbDescendents <- qcspqb <- kkmdrv
<- opiSem <- opiprs <- kksParseChildCursor <- rpiswu2 <-
kksLoadChild
<- kxsGetRuntimeLock <- kksfbc <- kkspsc0 <- kksParseCursor <-
opiosq0
<- kpoal8 <- opiodr <- ttcpip <- opitsk <- opiino
<- opiodr <- opidrv <- sou2o <- opimai_real <- ssthrdmain
<- main <- libc_start_main <- start

出现这个报错的的原因是BUG 25495749
于是解决方法便是安装对应此bug的补丁包