Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

disbale table compression

omkarmNov 5 2018 — edited Nov 10 2018

Hi I am new to DB administration, and I am trying to disable table compression (OLTP) by altering the undocumented parameter "_oltp_compression" in Oracle 12c by setting it to "FLASE". After setting it, I have tried the following example. I am still be able to compress for oltp. Is there a way to completely disable it? Please let me know.

CREATE TABLE test_tab (
  2    id            NUMBER(10)    NOT NULL,
  3    description   VARCHAR2(100) NOT NULL,
  4    created_date  DATE          NOT NULL,
  5    created_by    VARCHAR2(50)  NOT NULL,
  6    updated_date  DATE,
  7    updated_by    VARCHAR2(50)
  8  )
  9  COMPRESS;

Table created.

Elapsed: 00:00:00.13

alter table test_tab move compress for oltp;

Table altered.

Thanks in advance

Om

Comments
Post Details
Added on Nov 5 2018
2 comments
302 views