Apparently Oracle wants the default temporary tablespace to be locally managed when upgrading
from 10.1 to 10.2. When running utlu102i.sql script it throughs this warning if your temp
tablespace is dictionary managed:
--> SYSTEM tablespace is adequate for the upgrade.
.... minimum required size: 347 MB
WARNING: --> TEMP tablespace is not large enough for the upgrade.
.... currently allocated size: 0 MB
.... minimum required size: 68 MB
.... increase current size by: MB
.... tablespace is NOT AUTOEXTEND ENABLED.
I am not sure what happens if you ignore this warning because I didn't, what I did was I
created a locally managed temporary tablespace and made it the temporary tablespace of SYS
and SYSTEM:
SQL> alter user sys temporary tablespace temp_local;
SQL> alter user system temporary tablespace temp_local;
After doing that the warning was gone.
|