-
EM inconsistent with real data in table.
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.
-
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
-
Forgot to COMMIT after you inserted those rows?
Jurij Modic
ASCII a stupid question, get a stupid ANSI
24 hours in a day .... 24 beer in a case .... coincidence?
-
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.
-
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.
Last edited by Mr.Hanky; 05-24-2006 at 03:05 PM.
I remember when this place was cool.
-
Tell the truth ... you miss us don't you?
-
Thanks for advice Mr.Hanky Panky .
-
There is a new "Genius" in town!
I remember when this place was cool.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|