Re: Tablespace "2"

To find out which tablespace this is, issue the following:

SELECT name FROM sys.ts$ WHERE ts#=2;

HTH,
Brian

Niall Litchfield wrote:
>
> yes it would.
>
> --
> 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
>
> ******************************************
> "Dan Boxall" <djboxall_at_taz.qinetiq.com> wrote in message
> news:9v5671$lvc$1_at_hamble.qinetiq.com...
> > Would it be the id for the tablespace??
> >
> > "Jaret Lafoudravecmonhné" <toto_at_toto.com> wrote in message
> > news:9v55h8$1v5$1_at_reader1.imaginet.fr...
> > > Hello !
> > >
> > > I've got this error :
> > >
> > > ORA ERROR * ORA-03232: unable to allocate an extent of 63 blocks from
> > > tablespace 2
> > >
> > >
> > > As i've no tablespace named "2", I wonder what this "2" refers ?
> > >
> > >
> > >
> > >
> > > --
> > > Ludovic
> > >
> > >
> >
> >
Received on Wed Dec 12 2001 - 08:11:45 CST