Database Administration (MOSC)

MOSC Banner

Compression, Tablespace vs Table in 12c R2.

edited Apr 3, 2018 5:00AM in Database Administration (MOSC) 6 commentsAnswered

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;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center