Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: inc. size of temp tablespace

Re: inc. size of temp tablespace

From: Vince Laurent <vincelaurent_at_sbcglobal.net>
Date: Tue, 08 Jun 2004 13:24:37 GMT
Message-ID: <ahfbc05ss110fo8kc75uglbo851rsfa422@4ax.com>


Thanks. I love google and of course found the solution after posting (which happens ALL the time - just when I think I have googled enough)

On Mon, 07 Jun 2004 21:10:21 GMT, "Luc Gyselinck" <Luc.Gyselinck_at_nospampandora.be> wrote:

>Is it a DATAFILE or a TEMPFILE ? Temporary tablespaces can (as of Oracle8i)
>be created with DATAFILEs or TEMPFILEs.
>
>SQL> alter database tempfile '/oracle/SND/sapdata1/temp/temp1.data' resize
>200M;
>
>
>"Vince Laurent" <vincelaurent_at_sbcglobal.net> wrote in message
>news:sil9c01bb74it6c15gckhiml4d1agb2ds5_at_4ax.com...
>> Why when I do this I get an error:
>>
>> SQL> alter database datafile '/oracle/SND/sapdata1/temp/temp1.data'
>> resize 200M;
>> alter database datafile '/oracle/SND/sapdata1/temp/temp1.data' resize
>> 200M
>> *
>> ERROR at line 1:
>> ORA-01516: nonexistent log file, datafile, or tempfile
>> "/oracle/SND/sapdata1/temp/temp1.data"
>>
>> when the file and the path exists?
>>
>> sapsnd:orasnd 32> pwd
>> /oracle/SND/sapdata1/temp
>> sapsnd:orasnd 33> ls -lt
>> total 200848
>> -rw-rw-rw- 1 orasnd dba 104865792 Jun 7 15:41 temp1.data
>>
>> Here is what I am running:
>>
>> SQL> select * from v$version;
>>
>> BANNER
>> ----------------------------------------------------------------
>> Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
>> PL/SQL Release 9.2.0.4.0 - Production
>> CORE 9.2.0.3.0 Production
>> TNS for HPUX: Version 9.2.0.4.0 - Production
>> NLSRTL Version 9.2.0.4.0 - Production
>>
>> In other words, what is the easiest way to increase the size
>> of the temporary tablespace?
>>
>> Thanks!
>> Vince
>>
>> p.s. Tried:
>> SQL> alter tablespace psaptemp1
>> 2 add datafile '/oracle/SND/sapdata1/temp/temp1.data2' size 200M;
>> alter tablespace psaptemp1
>> *
>> ERROR at line 1:
>> ORA-03217: invalid option for alter of TEMPORARY TABLESPACE
>>
>
Received on Tue Jun 08 2004 - 08:24:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US