Database DataWarehousing (MOSC)

MOSC Banner

ORA-02149: Specified partition does not exist

edited Jan 14, 2010 1:05AM in Database DataWarehousing (MOSC) 7 commentsAnswered ✓

Hi,

I am executing one merge command, and I ended up getting this error.

=================================================================
ORA-12801: error signaled in parallel query server P004

ORA-02149: Specified partition does not exist

=================================================================

I checked the partitions and sub-partitions, they exist and functioning perfectly
fine when done for other previous months. Also tried adding "noparallel" hint.
Please let me know if anyone has encountered this issue. I cudn't get any definite
solution for this .

Thanks & Regards
Darshana Dhanaraj

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center