Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Drop Partiton ORA-04024 & ORA-04045

N_RajDec 15 2015 — edited Dec 15 2015

Hi All,

Os : Redhat

DB : 11.2

We got the below error while add/drop the partition.

ERROR at line 1:

ORA-00604: error occurred at recursive SQL level 1

ORA-04045: errors during recompilation/revalidation of GGUSER.FILE_SEPARATOR

ORA-04024: self-deadlock detected while trying to mutex pin cursor 0x7AFBCF6E8

Thanks,

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 12 2016

Added on Dec 15 2015

#general-database-discussions

7 comments

1,698 views