9iR2 to 10gR2 migration - Script running too slow
Currently we are doing 9iR2 to 10gR2 migration. As part of manual migration activity, am currently executing the script u0902000.sql. But this script is running (or could be hanging) since 24 hours.
Please please let me know is this normal? or is it hanging? How I can check?
script is hanging after this point
grant insert, delete on drv$unindexed2 to public
ERROR at line 1:
ORA-00942: table or view does not exist
My database in Unix server & 160 GB size
Thanks a lot for your inputs & help
TAke the trace of the session and find out the problematic SQL, Then check it out why it's slowing down. Seems like sql's using different explain plan in 10g.
I would restore from the backup the database and then once again run
and then spool and run
and see if you are missing something obivious.
Click Here to Expand Forum to Full Width