Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: extending tablespace TEMP
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