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-34061: (MSEXECUT11) Session-only values cannot be added to non-unique concat dimension workspace object, or any of its base dimensions.

1 Answers  


NID-00506: SETNAME Set a new database name only NO

1 Answers  


ORA-30119: unable to obtain a valid value for 'string'

1 Answers  


ORA-07401: sptrap: cannot restore user exception handlers.

1 Answers  


ORA-37112: OLAP API requires Oracle 9.2 or later

1 Answers  






TNS-12682: Login failed: the SecurID card is in next PRN mode

1 Answers  


ORA-12483: label not in OS system accreditation range

1 Answers  


ORA-03218: invalid option for CREATE/ALTER TABLESPACE

1 Answers  


AMD-00117: input file "string" not found

1 Answers  


NCR-03003: NCRO: Unexpected message

1 Answers  


ORA-13637: Executing or modifying task string is disallowed until the task is reset to its initial state.

1 Answers  


TNS-00519: Operating system resource quota exceeded

2 Answers  


Categories