ORA-Errors

ORA-10567: Redo is inconsistent with data block (file# 4, block# 2, file offset is 16384 bytes)

ORA-Errors / By

We got the below error in one of our physical standby databases today. ORA-10567: Redo is inconsistent with data block [adrotate banner=”1″] Problem Description : ORA-00600: internal error code, arguments: [3020], [4], [2], [16777218], [], [], [], [], [], [], [], [] ORA-10567: Redo is inconsistent with data block (file# 4, block# 2, file offset …

ORA-10567: Redo is inconsistent with data block (file# 4, block# 2, file offset is 16384 bytes) Read More »

ORA-23515: materialized views and/or their indices exist in the tablespace

ORA-Errors / By

When I was trying to drop a tablespace, I got then below error. ORA-23515: materialized views and/or their indices exist in the tablespace The Oracle documentation has given a clear information about the resolution steps we need to perform. According to Oracle ORA-23515 means. Description ORA-23515: materialized views and/or their indices exist in the tablespace …

ORA-23515: materialized views and/or their indices exist in the tablespace Read More »