CONTENTS_BLOB is Shown as Missing in View Objects Utility

(Doc ID 260869.1)

Last updated on APRIL 06, 2018

Applies to:

Oracle Repository - Version: 6.5 to 9.0.2 - Release: Designer 6i to Designer 9i
Information in this document applies to any platform.
Repository Administration Utility
'View Objects' Utility
Missing Object

Symptoms

The object name CONTENTS_BLOB is missing when checking the status of the
repository using the View Objects utility.
The table I$SDD_FILES exists and contains the column CONTENTS_BLOB of type
BLOB, so it is not possible to Reload it.

Executing the following SQL statement, connected as the repository owner:
   select *
     from user_objects
    where object_type='LOB';

does not return an object named CONTENTS_BLOB, but an object named SYS_LOBxxxxxxxxxxxxxxxx$$.

Executing the following SQL statement, connected as a DBA user:
   select table_name, column_name, segment_name
     from user_lobs;

returns the following output:
    TABLE_NAME
    ------------------------------
    COLUMN_NAME
    -------------------------------
    SEGMENT_NAME
    ------------------------------
    I$SDD_FILES 
    CONTENTS_BLOB        
    SYS_LOBxxxxxxxxxxxxxxxx$$


where the SEGMENT_NAME returned is the same returned from the previous command.

There is no error uploading a file into the repository.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms