ORA-34177: (MXCHGDCL19) number cannot be deleted because one
or more partitioned variables instantiate it.



ORA-34177: (MXCHGDCL19) number cannot be deleted because one or more partitioned variables instanti..

Answer / guest

Cause: User attempted to CHGDFN DELETE a partition template,
but some partitioned variable had data in the partition
specified for deletion.

Action: Drop the partitions that are causing the problem,
then retry.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-31409: one or more values for input parameters are incorrect

1 Answers  


IMP-00060: Warning: Skipping table "string"."string" because object type "string"."string" does not exist or has different identifier

0 Answers   Olivetti,


ORA-29533: attempt to overwrite class or resource string while defining or compiling string.string

1 Answers  


ORA-02818: Less than the number of blocks requested was read in

1 Answers  


TNS-12687: Credentials expired.

1 Answers  


ORA-24315: illegal attribute type

1 Answers  


PLS-00615: type mismatch found at 'string' between CASE operand and WHEN operands

1 Answers  


RMAN-08549: database name (or lock name space) used for search: string

1 Answers  


ORA-01742: comment not terminated properly

1 Answers  


ORA-26101: tablespace # in file header is string rather than string for file string

1 Answers  


ORA-26089: LONG column "string" must be specified last

1 Answers  


ORA-07305: ksmcsg: illegal database buffer size.

1 Answers  


Categories