Re: ora-03232

On 6 nov, 17:02, markg22..._at_yahoo.com wrote:
> ORACLE 8i     (we are in process of upgrading to 10g).
>
> UNIX solaris 5.8  (we are moving to new box).
>
> We recovered our production database in our current environment with
> RMAN.
>
> We started getting ORA-25153.
>
> We added the old tempfile to the temporary tablespace and resized it
> at the same time. (don't know if this makes a difference).
>
> We are now getting ORA-03232 on random queries. These are
> queries that have always run even when the tempfile was only 2GB.
> It is now 10GB.
>
> We have not bounced the database since the recover, as this is a
> production database.
>
> Could anyone please help  ?
>
> Thank you.

Please make sure for every error you post, you include the error text. You can get the error text from the online documentation. Please do not expect everyone knows all errors from memory and/or is going to look the error up on your behalf. This is a forum of volunteers.

--
Sybrand Bakker
Senior Oracle DBA