Re: Upgrade to 10g Issue

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Wed, 08 Feb 2006 20:12:22 +0100
Message-ID: <dsdfqm$r6e$01$1@news.t-online.com>

amerar_at_iwc.net schrieb:
> Hi All,
>
> We are upgrading to 10g. According to the docs, you are supposed to
> run this SQL script to gather info on your database: utlu102i.sql
>
> When we rna that utility, we received this error:
>
> "ORA-25143: Temporary Tablespace Empty"
>
> Not sure what that means, or why it is causing this script to have
> issues??
>

Temporary Tablespace Empty means your temporary tablespace has no tempfiles (often after duplicate database without adding tempfiles). But ORA-25143 means somewhat different:

25143, 00000, "default storage clause is not compatible with allocation policy"

// *Cause: default storage clause was specified for a tablespace with
//         AUTOALLOCATE or UNIFORM policy
// *Action:  Omit the storage clause

Best regards

Maxim Received on Wed Feb 08 2006 - 13:12:22 CST