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-07639: smscre: SGA pad area not large enough (string bytes required)

1 Answers  


ORA-14619: resulting List subpartition(s) must contain at least 1 value

1 Answers  


ORA-06257: NETNTT: cannot send command line to shadow process

1 Answers  


ORA-02379: profile string already exists

1 Answers  


UDI-00005: unexpected End-Of-File encountered while reading input.

1 Answers  






RMAN-06420: some files could not be proxy restored - aborting restore

1 Answers  


ORA-01754: a table may contain only one column of type LONG

1 Answers  


NNO-00309: server restarting

1 Answers  


ORA-28164: REVOKE already specified

1 Answers  


DRG-10535: failed to optimize text index string

1 Answers  


ORA-06039: NETDNT: connect failed

1 Answers  


TNS-01162: Syntax error in the address resolved from the spawn alias: string

1 Answers  


Categories