Re: Tablespace numbering

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: 23 Jul 2001 06:20:28 -0700
Message-ID: <a20d28ee.0107230520.6743fe92@posting.google.com>

Dino Hsu <dino1_nospam_at_ms1.hinet.net> wrote in message news:<jnlnlto6kfuomlu5h83ffn7o86hlo9debv_at_4ax.com>...
> Dear all,
>

[snip]
> 2001/07/23 PM 03:46:12 2 00000000 DA DMS-E-GENERAL, A
> general exception has occurred during operation 'asynchronous open'.
> 2001/07/23 PM 03:46:12 2 00000000 DA ORA-03232: unable to
> allocate an extent of 8 blocks from 'tablespace 9'
> 2001/07/23 PM 03:46:12 2 00000000 DA
> 2001/07/23 PM 03:46:12 2 00000000 DA (TR0109) Transformer
> couldn't read the data source.
>
> The most suspicious error is this one:
> ORA-03232: unable to allocate an extent of 8 blocks from 'tablespace
> 9'
>
> A tablespace is normally identified by its name, but not a number, how
> do you identify the 'talbespace 9' here?
>
> Thanks,
> Dino

Externally yes, internally no.
Every tablespace has an id.
Just describe dba_tablespaces (in 8i) and write a query for the tablespace with id =9, in Oracle 7 select name from sys.ts$ where ts# = 9

Regards,

Sybrand Bakker, Senior Oracle DBA Received on Mon Jul 23 2001 - 08:20:28 CDT