short of dropping the tablespace you can't. you could of course drop the
tem,p tablespace - delete the files from the os and then recreate a new temp
tablespace - prefereably of type temporary.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
"quentin_compson" <quentincompson1910_at_yahoo.com> 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
Received on Wed May 22 2002 - 07:47:07 CDT
