SAP Knowledge Base Article - Preview

2805535 - SYS.BLCKFREESPACE (TYPE) invalid during Oracle upgrade

Symptom

During Oracle 18c upgrade the @pre_upgrade_checks.sql show the following warning, Invalid object:

//////////////////
List of invalid objects:
SYS.BLCKFREESPACE (TYPE)
**********************************************************************
Generic Pre-Upgrade Warnings
**********************************************************************
WARNING: ----> INVALID_SYS_OBJECTS
               There are invalid objects in the SYS schema.
               Invalid SYS objects can cause the database upgrade to fail.
               Check why these objects are invalid before upgrading
               the database.
//////////////////


Read more...

Environment

Oracle Database

Keywords

BLCKFREESPACE, SYS, Invalid, 18c, Upgrade, Tuning, Script, Standard, Object , KBA , BC-DB-ORA , Oracle , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.