Skip to Main Content

SQL & PL/SQL

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!

ORA-00904: "CUSTOM_FLAG": invalid identifier

user8879206Feb 10 2015 — edited Feb 18 2015

Hi Guys,

Need you expert advise on this. This column does exists in my table but while gathering stats it throws this error. Any idea how to solve this?

I searched and have gone through many documents but did not get any answer as of now. It seems oracle bug. Any comments would be appreciated.

My table is partitioned on business_date and sub-partitioned on name. It has 4 indexes as well. But we don't have any index on CUSTOM_FLAG column. This column has only two values Y or NULL. Fact table contains both types of values. I am using oracle Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production (PL/SQL Release 11.2.0.2.0 - Production).

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 11 2015
Added on Feb 10 2015
3 comments
406 views