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: Shrink the datafile of a Temporary Tablespace

Re: Shrink the datafile of a Temporary Tablespace

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: Fri, 09 Nov 2007 04:30:23 -0800
Message-ID: <1194611423.082210.319040@z24g2000prh.googlegroups.com>


On Nov 9, 4:56 am, Kurt-Erich.Fin..._at_hte-company.de wrote:
> Oracle Standard Edition 10.2 on Debian
>
> Hello,
> some sorting etc was done on our database cause the temp tablespace to
> increase dramtically.
> Since we do a cold backup frequently the large temp datafile causes
> some trouble.
> In the past I shrank the temp tablespace by creating a new temp
> tablespace and setting it as the default tablespace.
> Then I dropped the old tablespace and deleted the datafile.
>
> >CREATE TEMPORARY TABLESPACE TEMPnew TEMPFILE 'tempnew.dbf' SIZE 20M REUSE AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED
> >ALTER DATABASE DEFAULT TEMPORARY TABLESPACE TEMPnew
> >ALTER DATABASE drop TABLESPACE TEMP including contents
>
> here I get : ORA-01900: LOGFILE keyword expected
>
> What does that mean? I searched metalink and the internet but did not
> find any useful explanation.
>
> regards
>
> Kurt-Erich

You described your original problem as the tablespace growing larger than you wanted it to. However you did not limit the size of the next one you created. Looks like the original problem will just come back eventually. Received on Fri Nov 09 2007 - 06:30:23 CST

Original text of this message

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