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: Identifying tablespace name

Re: Identifying tablespace name

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Mon, 11 Mar 2002 16:46:00 -0000
Message-ID: <3c8cdf51$0$8512$ed9e5944@reading.news.pipex.net>


so it is. my error.

--
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

******************************************
"dan" <dan_at_dan.dan> wrote in message
news:DI4j8.141$pM2.59727_at_zonnet-reader-1...

> Isn't the system tablespace 0 ?
>
> DJP
>
>
> "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
> news:3c8cc85e$0$233$ed9e5944_at_reading.news.pipex.net...
> > Hi
> >
> > The generic answer to this is that the reference is found in
v$tablespace.
> > However tablespace 1 is always the system tablespace.
> >
> > HTH
> >
> >
> > --
> > 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
> >
> > ******************************************
> > "Glen Parker" <raistlinxw_at_aol.com> wrote in message
> > news:4ad6d686.0203110624.5f6055e2_at_posting.google.com...
> > > Hello,
> > >
> > > I've got a query that is producing the following error message.
> > >
> > > ERR: DBD::Oracle::st execute failed: ORA-03232: unable to allocate an
> > > extent of 14 blocks from tablespace 1 (DBD ERROR: OCIStmtExecute).
> > >
> > > In reading older posts, I think I've figured out what the problem
> > > might be, but I'm having the darndest time figuring out which
> > > tablespace is having the problem. How do I make sense of "tablespace
> > > 1"? Is "1" some sort of Tablespace ID? I do not have a tablespace
> > > with that exact name (Not according to SELECT TABLESPACE_NAME FROM
> > > DBA_TABLESPACES;)
> > >
> > > Any ideas what to do with this information? Thanks in advance.
> > >
> > > Glen
> >
> >
>
>
Received on Mon Mar 11 2002 - 10:46:00 CST

Original text of this message

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