Article - CS29324

What is stored in BLOBS tablespace in Oracle database of Windchill

Modified: 13-Dec-2023   


Applies To

  • Windchill PDMLink 9.0 to 12.0
  • Oracle 10g, 11g

Description

  • What is stored in BLOBS tablespace of Oracle database?
  • Why the BLOBS tablespace size is very large?
  • Any available reports or techniques to list what content is held in BLOBS?
  • How big is the StreamData table?
  • How much unused BLOB tablespace is there on my system?
  • What tables takes up space in BLOBS tablespace?
  • Following error may be returned:
java.io.IOException: ORA-01691: unable to extend lob segment SCHEMA_NAME.SYS_LOBXXXXXXXX by 4096 in tablespace BLOBS
This is a printer-friendly version of Article 29324 and may be out of date. For the latest version click CS29324