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

Home -> Community -> Usenet -> c.d.o.misc -> Re: how do i delete datafile from TEMP table?

Re: how do i delete datafile from TEMP table?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 22 May 2002 07:41:54 -0700
Message-ID: <a20d28ee.0205220641.1edd053c@posting.google.com>


quentincompson1910_at_yahoo.com (quentin_compson) wrote in message news:<77872ad1.0205220220.6d0d4ff1_at_posting.google.com>...
> i'm new. i added some datafiles in correctly to the TEMP tablespace
> to fix the following error (ORA-01652: unable to extend temp segment
> by 256 in tablespace TEMP). but i added them incorrectly using OEM,
> so how can i get rid of them?
>
> tia

Not!
Please drop and recreate the tablespace. Generally speaking you should resize datafiles below 2G instead of adding new ones, especially if they are on the same disk.

Hth

Sybrand Bakker
Senior Oracle DBA Received on Wed May 22 2002 - 09:41:54 CDT

Original text of this message

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