Re: Need help on "alter tablespace" command.

From: Ian Hariott <ihariott_at_caritas.ab.ca>
Date: 8 Feb 1995 19:47:16 GMT
Message-ID: <3hb744$b6h_at_gnho.caritas.ab.ca>

>In article <3h0fdq$c9s_at_louie.udel.edu>, kalyanas_at_stimpy.eecis.udel.edu
says...

Hi!

        Could someone help me with the "alter tablespace" command on ORACLE
        7.0. The scenario is as follows:
?
        There is a table (TABLEA) that has around 25000 records and another
?        table (TABLEB) that has around 4000 records. FIELDA is common to
?        both TABLEA and TABLEB.

?        When the following command is issued,

?        DELETE FROM TABLEA
?                WHERE LENGTH(FIELDA) = 11 AND
                SUBSTR( FIELDA, 1, 8 ) IN 
?                (SELECT (FIELDA) FROM TABLEB)

        ORACLE responds with the following error message.

        Unable to extend temp segment by 18 in tablespace TEMP.

        The manual suggests running the "alter tablespace" command when 
this


>        error is encountered. When this command was used to change the 

 initial


>        extent parameter, the number (18) kept decreasing until a 

 particular


>        point (12) and then started increasing (147) again. Could someone 

 throw 


>        some light on what is happening.

>

>        Any help is appreciated.

>        Cheers

>        Pramod.

 
-- 
Ian Hariott                     ihariott_at_caritas.ab.ca

Have you ever evaluate you database to see if any tuning is required ? From what you said, and looking at your query, you may not have enough space in your temporary tablespace to support your current processing requirements. My first suggestion is to increase your TEMPORARY TABLESPACE size; the easiest way to do this is to ADD an additional DATAFILE to your temporary tablespace. If you do this, your problem should be solved.

peace Received on Wed Feb 08 1995 - 20:47:16 CET