Oracle Error ORA-22995: TABLESPACE DEFAULT option is invalid in this context

Oracle Error Message

ORA-22995: TABLESPACE DEFAULT option is invalid in this context

Reason for the Error

TABLESPACE DEFAULT option can be specified for LOB columns only in the following contexts:

– at the table level for a partitioned table

– at the partition level for a composite partition. An attempt was made to use the TABLESPACE DEFAULT option in a different context.

Solution

Remove the TABLESPACE DEFAULT option.