On Mon, 12 Feb 2007 02:06:31 +0800, DA Morgan wrote
(in article <1171217190.547678_at_bubbleator.drizzle.com>):
> steve wrote:
>> Hi,
>> I have the following situation
>>
>> Oracle Database 10.2 Upgrade Status Utility 02-11-2007 09:54:05
>> .
>> Component Status Version HH:MM:SS
>> Oracle Database Server VALID 10.2.0.3.0 00:16:47
>> JServer JAVA Virtual Machine VALID 10.2.0.3.0 00:04:21
>> Oracle XDK VALID 10.2.0.3.0 00:00:26
>> Oracle Database Java Packages VALID 10.2.0.3.0 00:00:37
>> Oracle Text VALID 10.2.0.3.0 00:00:20
>> Oracle XML Database VALID 10.2.0.3.0 00:01:55
>> Oracle Data Mining VALID 10.2.0.3.0 00:00:31
>> OLAP Analytic Workspace VALID 10.2.0.3.0 00:00:39
>> OLAP Catalog VALID 10.2.0.3.0 00:01:03
>> Oracle OLAP API VALID 10.2.0.3.0 00:01:01
>> Oracle interMedia VALID 10.2.0.3.0 00:06:00
>> Spatial VALID 10.2.0.3.0 00:00:54
>> Oracle Ultra Search INVALID 9.2.0.6.0 00:00:00
>> Oracle Enterprise Manager VALID 10.2.0.3.0 00:01:21
>>
>>
>>
>> the ultrasearch is sitting at 9.2 in my 10.2 database. I need to totally
>> remove ultrasearch and reinstall it.
>>
>> Which scripts do i need to execute to do this.
>>
>>
>> Steve
>
> You should verify with metalink but I'd look at these four scripts for
> more information.
>
> $ORACLE_HOME/rdbms/admin/c1002000.sql
> $ORACLE_HOME/rdbms/admin/cmpdbmig.sql
> $ORACLE_HOME/rdbms/admin/utlu102i.sql
> $ORACLE_HOME/rdbms/admin/utlu102x.sql
>
> Likely it is the second one but validate and test first.
>
thanks DA, I spent rather a long time ploughing thru the 10g documentation,
skipping from one place to another all without sucess.
Received on Wed Feb 14 2007 - 16:06:34 CST