Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Identifying tablespace name
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:13:29 CST