Re: Identifying tablespace name

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Mon, 11 Mar 2002 15:08:01 -0000
Message-ID: <3c8cc85e$0$233$ed9e5944@reading.news.pipex.net>

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 - 09:08:01 CST