Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: 10.2 Upgrade Information Utility
On 16 Dec 2005 02:38:32 -0800, "News" <Contact_404_at_hotmail.com> wrote:
>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 ?
Read the last line carefully.
Alter database datafile|tempfile '<filename>' autoextend on next ...M max ... M
>
>**********************************************************************
>
>Miscellaneous Warnings
>
>**********************************************************************
>
>.... USER SYSTEM has 6 INVALID objects.
>
>
>2. how to know which objects are invalid and how to correct problem ?
just run @?/rdbms/admin/utlrp from sqlplus connect as SYS.
If you still have invalid objects
select owner, object_name, object_type
from dba_objects
where status = 'INVALID'
issue the appropiate ALTER <object_type> <owner>.<object_name> compile
command to rectify this.
Pretty basic stuff for a DBA
-- Sybrand Bakker, Senior Oracle DBAReceived on Fri Dec 16 2005 - 05:03:38 CST