EM inconsistent with real data in table.
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: EM inconsistent with real data in table.

  1. #1
    Join Date
    Apr 2006
    Posts
    16

    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.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    errors?

  3. #3
    Join Date
    Apr 2006
    Posts
    16
    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.

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    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

  5. #5
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    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?

  6. #6
    Join Date
    Apr 2006
    Posts
    16
    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 02:59 PM.

  7. #7
    Join Date
    Jan 2001
    Posts
    3,131
    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 04:05 PM.
    I remember when this place was cool.

  8. #8
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    Tell the truth ... you miss us don't you?
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  9. #9
    Join Date
    Apr 2006
    Posts
    16
    Thanks for advice Mr.Hanky Panky .

  10. #10
    Join Date
    Jan 2001
    Posts
    3,131
    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
  •  


Click Here to Expand Forum to Full Width