You can add a datafile to the tablespace. It looks like in this case it is
the temporary tablespace which is used for large sorts. I suspect you get it
during a long running query. To add a datafile to a tablespace the syntax
is:
alter tablespace TABLESPACE_NAME add datafile 'FULL_PATH_AND_FILE_NAME' size
XXXM;
Which would add a data file of XXX megs. You do not have to take the
tablespace offline. You can have the system up and running.
Jim
<amerar_at_ci.chi.il.us> wrote in message news:7sno6a$7dl$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 - 09:20:01 CDT
