Monday , May 29 2023

ORA-00600: internal error code, arguments: [qcsprfro_tree:jrs present]

Due to an unknown situation in Oracle 11g databases, “ORA-00600: internal error code, arguments: [qcsprfro_tree: jrs present]” error is received during refresh of some materialized views.

The problem is identified as a “Could Not Reproduce” bug, but there is no patch because it cannot be recreated.

The error received during the operation is as follows.

In order to solve the problem, the relevant materialized view needs to be dropped and recreated. Then the error will not repeat.


About dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *