version : 11.2.0.4.0
Hello guys, i have a user who when accessing a table us01.tab1 is getting the "OCI-21700: object does not exist or is marked for delete" error.
when he does "select * from us01.tab1" he is getting that error.
but he is able to access that table if he types in individual column names of the table "select <column-1>, <column-2>, <column-3> from us01.tab1"
the user is also able to do "select count(*) from us01.tab1",
it is just with "select * " that is is having trouble with. he has all the necessary synonyms created.
Now, when I do a "select * from us01.tab1" I am getting the result i wanted. As far as i can see, there is nothing wrong with the table, it is in a valid state and it does exist in us01 schema.
Can some one help me out in finding what I am missing here.
Thank You