Re: Tablespace Question

first, check all your users to make sure that nobody has TEMP set as their default tablespace. Typically TEMP is used as the TEMPORARY TABLESPACE for your users, and gets used during sort operations. You can increase the size of the tablespace in one of two ways (assuming 7.3 or later). You can add an additional datafile (alter tablespace TSNAME add datafile '<path to new file>'; or you can use alter database datafile 'filename' resize 'newsize M';.

you can also verify if you have any objects in TEMP that don't belong there. select table_name, owner from dba_tablespace where tablespace_name = 'TEMP'; or select index_name, owner from dba_indexes where tablespace_name = 'TEMP'; should get you started.

The fact that your temp tablespace is trying to extend dynamically may also indicate you have something going on that is causing you to perform sorts on disk instead of in memory.

HTH,
Roy

In article <7sno6a$7dl$1_at_nnrp1.deja.com>,   amerar_at_ci.chi.il.us wrote:
>
>
> 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.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Sep 27 1999 - 12:10:53 CDT