The Oracle default BLOB storage type is 'storage in row'. This type means that the BLOB data is stored in the row if its total size is less than or equal to 4KB. If the size is greater than 4KB, the entire BLOB is stored out of row and control information with a pointer is stored in its place.
HARFORMATTACHMENT, HARVERSIONDATA, and HARVERSIONDELTA each contain large BLOB data types configured for 'storage in row' and, therefore, are created in the HARVESTBLOB tablespace. If you determine that 'storage in row' is not the best option for your unique CA Harvest SCM configuration, you can change the setting to 'disable storage in row', recreate the table in HARVESTMETA tablespace, and configure the BLOB storage to HARVESTBLOB tablespace.
Note: For detailed BLOB storage information, see your Oracle documentation.
|
Copyright © 2013 CA.
All rights reserved.
|
|