Re: Tablespace numbering

On Mon, 23 Jul 2001 13:04:22 +0100, "Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote:

>have a look at dba_tablespaces I believe the TS# is the number you are
>looking for.
>>
>> snip...
>>
>> 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
>>
>

Sorry, I cannot find ts# or id in dba_tablespaces.

SQL> desc dba_tablespaces

 Name                                      Null?    Type
 ----------------------------------------- --------
----------------------------
 TABLESPACE_NAME                           NOT NULL VARCHAR2(30)
 INITIAL_EXTENT                                     NUMBER
 NEXT_EXTENT                                        NUMBER
 MIN_EXTENTS                               NOT NULL NUMBER
 MAX_EXTENTS                                        NUMBER
 PCT_INCREASE                                       NUMBER
 MIN_EXTLEN                                         NUMBER
 STATUS                                             VARCHAR2(9)
 CONTENTS                                           VARCHAR2(9)
 LOGGING                                            VARCHAR2(9)
 EXTENT_MANAGEMENT                                  VARCHAR2(10)
 ALLOCATION_TYPE                                    VARCHAR2(9)
 PLUGGED_IN                                         VARCHAR2(3)

Dino Received on Tue Jul 24 2001 - 20:19:24 CDT