Oracle Solution for Error ora-22995

Solution for Oracle Error ORA-22995

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

What triggered the Error:

BLESPACE DEFAULT option can be specified for LOB columns only in the following contexts: *- at the table level for a partitioned tabl. *- at the partition level for a composite partition. An attempt was made to use the TABLESPACE DEFAULT option in a different context.

What should we do to fix it:

move the TABLESPACE DEFAULT option.