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

In this post, you’ll learn more about the Oracle ErrorORA-33883: (MAKEDCL36) You cannot use the string attribute when you define an EXTERNAL partition with an existing target. with the details on why you receive this error and the possible solution to fix it.

Oracle Error Description

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

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

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

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

You can fix this error in Oracle by following the below steps

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.