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-31613: Master process string failed during startup.

1 Answers  


EXP-00042: Missing NLS_CHARACTERSET/NLS_NCHAR_CHARACTERSET in props$

1 Answers  


ORA-25403: could not reconnect

1 Answers  


DRG-11519: encounter error when exporting a LONG or LONG RAW column

1 Answers  


ORA-01583: unable to get block size of controlfile to be backed up

1 Answers  






ORA-31518: change column string already exists in CDC change table string.string

1 Answers  


ORA-02298: cannot validate (string.string) - parent keys not found

2 Answers  


IMP-00024: Only one mode (TABLES, FROMUSER, or FULL) can be specified

1 Answers  


SQL*Loader-00965: Error number disabling constraint string on table string

1 Answers  


ORA-01909: REUSE keyword expected

1 Answers  


ORA-23449: missing user name

1 Answers  


ORA-29548: Java system class reported: string

1 Answers  


Categories