Re: Issue upgrading to 10g

From: Maxim Demenko <mdemenko_at_gmail.com>
Date: Wed, 08 Feb 2006 20:23:26 +0100
Message-ID: <dsdgfe$pln$02$1@news.t-online.com>

amerar_at_iwc.net schrieb:
> Hi All,
>
> We are upgrading to Oracle 10g. According to the docs, we are to run a
> SQL script named: utl1012i.sql.
>
> When I do that, it aborts with the following error:
>
> ORA-25153: "Temporary Tablespace Empty"
>
> Any thoughts??
>

If
select tablespace_name from dba_tablespaces where contents='TEMPORARY' minus
select tablespace_name from dba_temp_files;

returns something, you can issue for this tablespace(s)

alter tablespace xyz add tempfile 'some_temp_file' size nnn;

Best regards

Maxim Received on Wed Feb 08 2006 - 13:23:26 CST