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 ONE Support launchpad (Login required).

Search for additional results

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