Well Niall, I think you're allowed :)
"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
news:3c8cdf51$0$8512$ed9e5944_at_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 - 11:07:24 CST
