In this post, you’ll learn more about the Oracle ErrorORA-34243: (MXDCL11) You can only use the string keyword when defining a COMPOSITE. with the details on why you receive this error and the possible solution to fix it.
Oracle Error Description
ORA-34243: (MXDCL11) You can only use the string keyword when defining a COMPOSITE.
Reason for the Error ORA-34243: (MXDCL11) You can only use the string keyword when defining a COMPOSITE.
User supplied the COMPRESSED keyword when defining an object that was not a COMPOSITE.
How to fix the Error ORA-34243: (MXDCL11) You can only use the string keyword when defining a COMPOSITE. ?
You can fix this error in Oracle by following the below steps
If the intent is to create a compressed composite, make sure that the object type is COMPOSITE. Otherwise, remove the COMPRESSED keyword from the command string and rerun.