DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: oracle 8i to oracle9i

  1. #1
    Join Date
    Sep 2001
    Posts
    120
    hi,

    i have done a mistake by making a user in system tablespace in oracle 8i and he has done quite a bit of work.

    i want to now make it on 9i and want to have all the users tables on 9i.

    i exported the user table on 8i and imported in 9i.

    it was ok it didnot give any error after importing in 9i.

    but when i insert something in table it give error

    ora-01502:index "portal_pk1" or partion of such index is in unsuable state.


    please help.

    thanks
    Saurabh Garg
    OCP 9i

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Rebuild the index ...

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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