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: extending tablespace TEMP

Re: extending tablespace TEMP

From: koert54 <koert54_at_nospam.com>
Date: Tue, 18 Dec 2001 12:58:23 GMT
Message-ID: <P3HT7.981$Ic7.287833141@hestia.telenet-ops.be>


Sorry - the procedure I'm thinking about won't work because the system tablespace is affected....
Ignore my previous message ...

"koert54" <koert54_at_nospam.com> wrote in message news:cjGT7.958$oK5.281677921_at_hestia.telenet-ops.be...
> > Oh, and I have added a datafile to the SYSTEM tablespace. Does anyone
know
> > how I delete it from the tablespace again? I have accidently deleted the
> > file on the harddrive, but I can't seem to find a way to remove it from
> > the tablespace?!?
>
> Yes it's possible - but only when no extents where allocated in that
> datafile ...
> I'm not going to post the procedure because it involves deleting records
> from the core data dictionary tables and thus,
> is not supported by Oracle (allthough I've seen them doing it myself) ....
>
> Anyhow if you do want to whack that datafile - just look for the procedure
> on deja/google (I posted it before)
>
>
>
> "Jan Eliasen" <eliasen_at_cs.auc.dk> wrote in message
> news:Pine.GSO.4.33.0112181052020.4488-100000_at_borg.cs.auc.dk...
> > Hi there.
> >
> > How do I do that? I'm trying to do a simple
> >
> > select * from h2alle one, h2alle two where one.dato = two.dato;
> >
> > but I get an error;
> >
> > ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
> >
> > How do I fix this? I can't find any information about it.
> >
> > Oh, and I have added a datafile to the SYSTEM tablespace. Does anyone
know
> > how I delete it from the tablespace again? I have accidently deleted the
> > file on the harddrive, but I can't seem to find a way to remove it from
> > the tablespace?!?
> >
> > --
> > Eliasen Jr.
> >
>
>
Received on Tue Dec 18 2001 - 06:58:23 CST

Original text of this message

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