Re: Storage (tablespace) questions

Did you check v$datafile to see that the change had actually taken effect?

And if so, what did you increase it by? It would have needed to be by just a bit more than the NEXT extent setting for the table.

Regards
HJR

--
--------------------------------------------------------------------------
Opinions expressed are my own, and not those of Oracle Corporation
Oracle DBA Resources:               http://www.geocities.com/howardjr2000
--------------------------------------------------------------------------



"Mike DiChiappari" <mike_at_mysticsoft.com> wrote in message
news:8r7c9m$qt8_at_dispatch.concentric.net...


>

> "Dave A" <dave_and_vanna_at_hotmail.com> wrote in message

> news:stc4heq3qmpv52_at_corp.supernews.com...

> > I'm not sure I understand the problem.  If I assume that the first (and

> > only) datafile was full, then your first and second methods wouldn't

 help.


> > The third option should have worked unless you increased the datafile

 size


> > at the OS level and not the database level.  Did you give the command to

> > resize the datafile from within Oracle?  The fourth option would work

> > because adding an additional file to the tablespace(within Oracle) would

> > have caused Oracle to realize there was more space available.

> >

> > --

> > Dave A

>

> I thought the third option should have worked (increasing the data file

> size) - especially AFTER having done the first two.  I assumed that

> increasing the maxextents of the table and tablespace didn't work because

> the datafile was full.

>

> I was surprised that increasing the data file size didn't work.  I did

> increase the file size at the database level.

>

> Mike

>

>