-
9iR2 to 10gR2 migration - Script running too slow
Hi,
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.
-
Hi
I would restore from the backup the database and then once again run
utlu102i.sql
and then spool and run
SQL> @utlu102i.sql
and see if you are missing something obivious.
regards
Hrishy
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|