10.2 Upgrade Information Utility

Oracle Database 10.2 Upgrade Information Utility 'utlu102i.sql' displayed

Database:

--> version: 9.2.0.4.0

--> compatible: 9.2.0.0.0

Tablespaces: [make adjustments in the current environment]

WARNING: --> TEMP tablespace is not large enough for the upgrade.

.... currently allocated size: 0 MB

.... minimum required size: 58 MB

.... increase current size by: MB

.... tablespace is NOT AUTOEXTEND ENABLED.

1. TEMP tablespace is 32 GB. How much do I need to increase it ?

   ---

Miscellaneous Warnings

.... USER SYSTEM has 6 INVALID objects.

2. how to know which objects are invalid and how to correct problem ? Received on Fri Dec 16 2005 - 04:38:32 CST