Re: 7.3.3 to 8.1.5 upgrade

Are you sure that it is really hanging.

The source$ table is likely to be one of the largest in the SYS schema (lots of text lines of all that pl/sql) so possibly you are generating a lot of redo, and getting checkpoint waits etc.

Can you get a handle on the wait event that the process is stuck on ? This may give some clues.

If necessary use svrmgrl and fire in:

    connect internal
    oradebug setospid {process id of shadow}     oradebug event '10046 trace name context forever , level 8'

--

Jonathan Lewis
Yet another Oracle-related web site: http://www.jlcomp.demon.co.uk

darenscott_at_my-deja.com wrote in message <7rj4cf$obt$1_at_nnrp1.deja.com>...
>When attempting an upgrade of a 7.3.3 instance to a 8.1.5 instance,
>the migration utility (mig) seems to be hanging when creating a simple
>table, i.e.
>
> create table source$ as select * from sys.source$;
>
>I think I have set up the environment to be able to perform this
>migration, i.e. 7.3.3 environment, 8.1.5 environment, tablespace
>checks, etc., but this consistently hangs at this point.
>
>Anybody else experience this problem, and if so what's the solution.
>
>
>
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.
Received on Mon Sep 13 1999 - 10:24:39 CDT