Re: Tablespace numbering

From: Yaroslav Perventsev <p_yaroslav_at_cnt.ru>
Date: Wed, 25 Jul 2001 10:31:03 +0400
Message-ID: <9jloo7$ro0$1@news247.cnt.ru>

Hello!

See v$tablespace.

Yaroslav.
Dino Hsu <dino1_nospam_at_ms1.hinet.net> ñîîáùèë â íîâîñòÿõ ñëåäóþùåå:o47sltc9j9v5hqd5r4ln2l1lbo91ggimoj_at_4ax.com...
> 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 Wed Jul 25 2001 - 01:31:03 CDT