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-15071: ASM disk "string" is already being dropped

1 Answers  


ORA-00449: background process 'string' unexpectedly terminated with error string

1 Answers  


PLS-00667: Element type of associative array should be pls_integer or binary_integer

1 Answers  


ORA-36808: (XSTBLFUNC04) The OLAP_TABLE function LEVELREL clause cannot declare number ADT fields from number AW fields.

1 Answers  


IMP-00089: Fine grain policy "string" not recreated on table/view "string"

1 Answers  


ORA-16521: unable to create generic template id

1 Answers  


ORA-35282: (SNSYN166) The format of the AGGREGATE function is: AGGREGATE(varname USING aggmap-name [COUNTVAR intvar-name] [FORCECALC])

1 Answers  


ORA-13415: invalid or out of scope point specification

1 Answers  


ORA-01627: rollback segment number 'string' is not online

1 Answers  


ORA-39117: Type needed to create table is not included in this operation. Failing sql is: string

1 Answers  


ORA-23365: site string does not exist

1 Answers  


ORA-01718: BY ACCESS | SESSION clause not allowed for NOAUDIT

2 Answers  


Categories