Strange Error, Never Expected.

is this the only table you have trouble with ?

Did you try --

select object_name, status from user_objects where status <> 'VALID'


just to see what the object status is ?

- Rajeev

I agree with the previous statements in that it looks like a data dictionary problem. I had something similar and the only thing that I could do was recreate the db.

One question: does it generate a trace file for you?

It's quite possible that there is something wrong with your data dict.

Create a new table and try to alter it's structure.

Keep this post updated.

Good Luck,
Pinakin.

I check the metalink and it was not informative. To be on the safer side, can you do


create table schema.new-name as select * from schema.old_table;

If you have any indices created under, then you have to recreate them. On the new table can you try altering the information what you would want to.


Sam

As a last resolute, you could rerun the catlog.sql and catproc.sql from $ORACLE_HOME/rdbms/admin and I think that would fix the problem for you.


Sam

hmmm... Sam, about running catproc and catalog.sql my understanding was that these rebuild the data dictionary for all the SYS objects and not for USER objects.

Catproc and catalog.sql are hard-coded scripts and have no idea of what user might have created so I am doubtful but I will be watching to see if that fixes the problem.

- Rajeev

One other thing that he could do is that export the user schema, drop the user and recreate the user and import the user schema. How does this sound??

Sam

okay Mister

the ball is in your court now; let us know what your findings were with the above suggestions !

Thanks to All,

I happen to find the Problem. There was a Trigger that was restricting to Modify.

Sorry! I could have explore first.

Thank a lot for all of you, who participated in it.

Thanks again.

Mind checking if you have ALTER TABLE privilege ?? :-)

-amar