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