Hello guys, I'm having a problem-I made a new user(new schema)and added a table inside it.I gave all object priveleges to "system" for the tables within this schema.Now,I can insert rows through SQL PLUS,I can see them too,but EM shows me no rows...it;s inconsistent with the latest table.I do commit the stuff in SQL.Also,I granted the create session privelege to this new user,but cannot login as him.
Can you please help me.Thanks.
I get no errors.When I select table and do View data,I see no rows.On the other hand,SQL Plus shows me 5 records which I just inserted.Logging off,and back on EM doesnt help either.
I'm operating as "system" in both,sql plus and EM.
Sorry this is sort of late, but just to follow up.
I did commit.Within EM interface, where it gives one line description of the tables (when a schema is selected), I saw that EM said: NO ROWS.
But Viewing data inside the table yielded rows that I had inserted.So, EM was giving incorrect summary of table.I should have gone one step ahead to see actually whether the table was empty or not.
edit: refreshing/logging out and back in did not change NO ROWS to actual number of rows in the table.
Last edited by dereliction; 05-24-2006 at 01:59 PM.