Oracle Error ORA-33883: (MAKEDCL36) You cannot use the string attribute when you define an EXTERNAL partition with an existing target.

Oracle Error Message

ORA-33883: (MAKEDCL36) You cannot use the string attribute when you define an EXTERNAL partition with an existing target.

Reason for the Error

User gave the TEMPORARY keyword in the definition of an external partition whose target variable was previously defined.

Solution

Any storage characteristics of the external partition are determined by the target variable. These attributes should be set when the target is defined, not when the external partition is defined.