Compression, Tablespace vs Table in 12c R2.
I am taking the plunge to migrate a DB from 11g to 12c R2. I am part time DBA and full time lazy.
The DB is ~600 GB of data in many tables and about 29 tablespaces. It has grown organically over the last 15-20 years. I was thinking it might be time to implement advanced compression as part of this move.
My main question is, "Will I get the same results if I create my tablespaces like;
CREATE BIGFILE TABLESPACE "MYTABLESPACE" DATAFILE 'D:\APP\ORACLE\ORADATA\MYDEV3\MYTEST3\MYTABLESPACE.TS' SIZE 1G AUTOEXTEND ON NEXT 1G MAXSIZE UNLIMITED LOGGING EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO DEFAULT COMPRESS FOR OLTP;