Hello Everyone.
I'm planning to apply compression for a readable only database.
But the customer does not want to pay for advance compression.
The customer wants to archive data on a yearly basis for some history tables and with the basic compression I can do it pretty well.
The question will be :
Do the customer need to pay for basic compression ?
like this for example : create table mytable compress as select * from my_other_table; -- I know that I need to rebuild the indexes every time insert data into that compressed table but that should be fine for me since is once a year.
or for using it in Datapump export/import.
Thanks in advance.