EM inconsistent with real data in table.

[dereliction]

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.

[davey23uk]

errors?

[dereliction]

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.

[davey23uk]

you say he cant log in though, what errors do you get when you try that

and if that new user cant log in, how did you create any tables

[jmodic]

Forgot to COMMIT after you inserted those rows?

[dereliction]

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.

[Mr.Hanky]

Analyze the table.

EM gets it's table info from the data dictionary, so it is only as accurate as your last analyze. Keep this in mind for the future.
It is the same as viewing table info from DBA_TABLES.

[slimdave]

Tell the truth ... you miss us don't you?

[dereliction]

Thanks for advice Mr.Hanky Panky .

[Mr.Hanky]

There is a new "Genius" in town!