Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Unable to extend Table by 315
Also, is the (autoextend) maxbytes setting larger than the current size of the tablespace?
Ezr Vinh wrote:
> First a stupid question: is the filesystem containing the tablespace
> full? That would prevent the tablespace from being able to grow.
> Another obvious question: are you sure your target table is in the
> tablespace you think it's in? (i.e. is it actually in the tablespace
> which has autoextend on, or is it in some other static tablespace? I
> don't know how big your database is, but it can get confusing managing
> tablespaces and what lives where).
>
> Also, are the target table's storage parameters appropriate for the
> small size of the table? You might want to check the other tables in
> the tablespace and see if they are using up more space than is necessary
> because of possible excessively large storage parameters.
>
> -Dave
>
> In article <spnv2tk5kb38jatrk03tospeiuoud2s1dr_at_4ax.com>,
> Harry <a_harrison_uk_at_yahoo.co.uk> wrote:
> > I have a tablespace with autoextend set to on - I'm running an "insert
into ... select from" query -
> > I know the query (well I'm pretty sure), will only generate 400
records but I keep getting the above
> > error
> >
> > Never seen it before - can someone please explain why & how to get
around it?
> >
> > Many thanks
> >
> > harry
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Sat Dec 09 2000 - 07:40:56 CST