CONTENTS_BLOB is Shown as Missing in View Objects Utility
Last updated on APRIL 06, 2018
Applies to:
Oracle Repository - Version: 6.5 to 9.0.2 - Release: Designer 6i to Designer 9iInformation 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 therepository 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