On Sat, May 12, 2001 at 02:22:08PM +0100, Paul Jakma wrote:
> unable to extend table xyz.234 in tablespace foo;
<snip>
> any ideas?
I started reading a book on Oracle the other day, so this is from the
mouth (or fingers) of a complete novice, but the book seemed to say that
when a new database is created, a certain amount of space is allocated for
each row, which equals the amount needed for the current columns, plus
extra space in each row for expansion, if extra columns are added in the
future.
And the book said that if this expansion space runs out, the solution is
to basically export the table, drop, and import again.
HTH!
Gary.
Maintained by the ILUG website team. The aim of Linux.ie is to
support and help commercial and private users of Linux in Ireland. You can
display ILUG news in your own webpages, read backend
information to find out how. Networking services kindly provided by HEAnet, server kindly donated by
Dell. Linux is a trademark of Linus Torvalds,
used with permission. No penguins were harmed in the production or maintenance
of this highly praised website. Looking for the
Indian Linux Users' Group? Try here. If you've read all this and aren't a lawyer: you should be!
