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
"Mike DiChiappari" <mike_at_mysticsoft.com> wrote in message
news:8r4t83$r3l_at_dispatch.concentric.net...
> I recently tried INSERTING some information to a database. I got the
> ORA-01653 error message saying that my table couldn't be extended. I
tried
> several things, none of which worked (but I thought they should have
> worked). I'd appreciate any comments.
>
> First, I tried increasing the extents for the table so it could grow
passed
> it max amount. That failed to improve the situation.
>
> Second, I tried increasing the extents allocated for the tablespace. That
> failed to improve the situation.
>
> Third, I tried increase the size of the datafile (only one, so far). That
> faile to improve the situation.
>
> Finally, I added a second data file to the tablespace and that worked.
>
> Why didn't any of the first three work?
>
> Thanks,
> Mike
>
>
Received on Sat Sep 30 2000 - 11:24:03 CDT
