|
|
Re: ORA-1653: unable to extend table by 8192 in tablespace [message #475838 is a reply to message #475819] |
Sat, 18 September 2010 02:10 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) |
John Watson
Messages: 8944 Registered: January 2010 Location: Global Village
|
Senior Member |
|
|
Some DBAs and sysadmins like to use standard sizes for datafile (I usually use 1G, or 2G, or 4G, and so on) in which case increase your datafile's size to the next boundary. Or add another datafile, of your standard size.
Alternatively, you could enable autoextend on the existing datafile(s), though some DBAs (including me) consider that to be lazy database administration. If you do use autoextend, define a sensible increment (the default is too small and will impact on performance) and a maximum size.
|
|
|