Re: Tablespaces

In article <7sno59$7di$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
>

Arthur, the message refers to you temp tablespace so it means you are running short of sort (temporary) extents.

You can query sys.dba_data_files for tablespace_name = 'TEMP' to see the number and size of files that make up the tablespace. You can query sys.dba_tablespaces to see the default storage (allocation) parameters for the temp segments. You may have plenty of overall space but just need to change the initial, next, and pctincrease to better utilize it.

You can add a file to a tablespace on the fly using the command alter tablespace temp
add datafile '/availdisk/filename' size 1024M;

I hope this helps.

--
Mark D. Powell -- The only advice that counts is the advice that  you follow so follow your own advice --

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Sep 27 1999 - 08:56:07 CDT