OAS BIplatform Schema Tables Compression License

Question

Hi, Would like to understand the compression enabled on the below Bi platform schemas are covered under Oracle DB license or OAS license? Please confirm

CSS_FILE_CONTENT

XMLP_DOCUMENT_STORE_PART

Thanks,

Gianni Ceresa · Accepted Answer

Hi @User_5TZYH ,

As long as you didn't modify those tables manually, the way they are created by the RCU is covered by the OAS license. They are "product's tables", the RCU does create them the way it needs them.

Of course it doesn't mean you can start using compression for free on your own tables, you don't have a license for that. Only the tables as they are generated by the RCU are allowed to use whatever feature the RCU used when creating them.

Michal Zima · Accepted Answer

@User_5TZYH

As for CSS_FILE_CONTENT table - here column DATA (when COMPRESSED_TYPE - gzip) is compressed using standard gzip compression. And you can use UTL_COMPRESS.lz_uncompress function from package UTL_COMPRESS to uncompress it. We are using it in our internal "governance routines" (dirty method accesing directly tables in BIPLATFORM schema, bypassing complete lack of official APIs - big product gap I am pointing out to every time …..)