Oracle Analytics Cloud and Server

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

OAS BIplatform Schema Tables Compression License

Accepted answer
182
Views
3
Comments
Rank 2 - Community Beginner

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

XMLP_DOCUMENT_STORE_PART      

Thanks,

Best Answers

  • 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.

  • Rank 7 - Analytics Coach

    @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 …..)

Answers

Welcome!

It looks like you're new here. Sign in or register to get started.