Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: how do i delete datafile from TEMP table?
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
![]() |
![]() |