Re: Tablespaces

Sort of yes, and sort of no.

In general, yes. When you get this message in your alert.log file it usually means that you have run out of space in the specified tablespace.

However, this message is pertaining to your TEMP tablespace which shouldn't be holding any objects (tables, indexes, etc.). The temporary tablespace is mainly used for sorting result sets. This error message probably was generated because some user cranked off some large query and had a SORT BY clause in it. If the query is integral to your operation, you may have to add space to the tablespace.

The easiest way to add space to a tablespace is to add a datafile. alter tablespace temp add '/u02/oradata/mysid/temp02.dbf' size 1000M

The tablespace does not have to be offline.

If you want to resize an existing datafile: alter database datafile '/u02/oradata/mysid/temp01.dbf' resize 1000M;

amerar_at_ci.chi.il.us wrote in message <7sno59$7di$1_at_nnrp1.deja.com>...
>
>
>Hello,
>
>Recently I have begun to see this message in our alert log:
>
>ORA-1652: unable to extend temp segment by 791 in tablespace TEMP
>
>Ok, this must means that the tables are growing and that the tablespace
>is no longer large enough to handle the tables right? Can I, and if so
>how, extend a tablespace? Do I need to take it offline? How can I see
>how large it is currently?
>
>Since I've never ran into this before, it is kind of a new situation for
>me. Any help would be appreciated.
>
>Thanks,
>
>Arthur
>amerar_at_ci.chi.il.us
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Mon Sep 27 1999 - 07:56:40 CDT