ORA-2180 or ORA-933 on CREATE or ALTER of a Tablespace with COMPRESS FOR ALL OPERATIONS;
(Doc ID 1419493.1)
Last updated on JULY 16, 2019
Applies to:Oracle Server - Enterprise Edition - Version: 184.108.40.206 to 220.127.116.11 - Release: 11.1 to 11.2
Information in this document applies to any platform.
CREATE TABLESPACE comp_test DATAFILE '/share_ic_1/compressed.dbf' SIZE 10G default compress for all operations;
--> SQL Error: ORA-02180: invalid option for CREATE TABLESPACE
ALTER TABLESPACE comp_test DEFAULT COMPRESS FOR ALL OPERATIONS;
--> SQL Error: ORA-00933: SQL command not properly ended
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document
|This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.|