Invalid identifier error after renaming columns and selecting from a table
saranyaNov 5 2008 — edited Nov 6 2008Hi,
10.2.0.2 RAC db.
We are doing the following rename columns on a partitioned table (let me call it test_partition)
alter table test_partition rename column abc to abc_old;
alter table test_partition rename column abc_new to abc;
After the above renames run, when we try to select from the table we get an invalid identifier error as follows
select count(*) from test_partition;
3:50:28 PM ORA-00904: "SCHEMANAME": invalid identifier
SCHEMANAME in the above error was the actual schemaname that owns the table.
Analyze table validate structure dint return any errors.
We have also tried to do the rename after disabling FK, still the same error happens.
Please help.
Thanks,
Sincerely,
Saranya Sivakumar