Index problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Index problem

  1. #1
    Join Date
    Jan 2001
    Posts
    230

    Question

    Hi:

    Oracle : 8.1.6
    O.S. : window NT

    I exp. the table from one database and imp. to another one..
    and tested and it was working..

    Then I dropped the index and recreated the index with out any changes (same as before) and it is not working..

    Also, I analyze the index and still not working..

    I know I could rebuild the index without dropping and recreating..

    If you have any suggestion, plese let me know...

    Thanks..




  2. #2
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    What do you mean by "It's not working"?

    A query is not using your index? If not, compute statistics on the entire table instead of just the index.

    The index is UNUSABLE? Rebuild it.
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  3. #3
    Join Date
    Jan 2001
    Posts
    3,131
    My question is why?
    If you truncated that table prior to the import then the index is trucated as well. It is also re-built upon import and by default analyzed.
    No?

    MH
    I remember when this place was cool.

  4. #4
    Join Date
    Jan 2001
    Posts
    230
    Hi:

    I have anylized the index and table but still having the same problem...
    Also, I truncted the table and reload the data using imp but still same problem..

    Then drop the table and imp. data and objects that works..

    After the imp, if I drop the index and recreate the index then it doesn't work..

    Also, I check the sattus of index and it is in VALID state..

    Any idea?

    Thanks.

  5. #5
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    What exactly "doesn't work" ????

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