Storage (tablespace) questions

From: Mike DiChiappari <mike_at_mysticsoft.com>
Date: 30 Sep 2000 14:27:15 GMT
Message-ID: <8r4t83$r3l@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 - 09:27:15 CDT