Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Clean Deliveries User Catalog Folder OBIEE 11G

Accepted answer
21
Views
2
Comments
Hector Andrade
Hector Andrade Rank 3 - Community Apprentice
in Oracle Analytics Cloud and Server

Hi community,

Do you know if there's a way to delete or purge the Deliveries Folder of each user in the OBIEE 11g Catalog? I know that there's a tag on instanceconfig file that can limit the size of each user folder, but do you know if there's a way to delete the Deliveries Folder is under /users/username/_delivers/_deliveries ?

Thanks,

Hector Andrade

Best Answer

  • Gianni Ceresa
    Gianni Ceresa Mod
    Answer ✓

    but we were uncertain if that could affect the catalog integrity, if it could be corrupted or with missing things on it.

    The catalog only recognize objects having a .atr file with the same name. If you don't have a .atr file, the object doesn't exist for the catalog. That's why when deleting content from outside OBIEE, you should make sure you delete both the file and the related .atr file. The file will be the one taking space, while the .atr is only a few hundreds of bytes. But you should make sure to delete both, that's how you guarantee the catalog integrity.

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod
    edited Apr 15, 2025 10:16PM

    Hi,

    The catalog in 11g is on disk, you can just delete the content of the folders (I would leave the folder as it doesn't take much space) on disk (by a script or a find + delete at the OS level) and job done (always delete the file and the corresponding .atr, to not confuse the catalog with ghosts).