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