[重慶思莊每日技術分享]-建立物化檢視時出現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的補丁包