Home » RDBMS Server » Server Administration » ORA-1653: unable to extend table by 8192 in tablespace (Oracle 10g)
ORA-1653: unable to extend table by 8192 in tablespace [message #475817] Fri, 17 September 2010 16:36 Go to next message
ganik70
Messages: 1
Registered: February 2009
Junior Member
Hi,

How much space exactly should I allocate if get rid of the error

"ORA-1653: unable to extend table by 8192 in tablespace"

Regards
Gani

Report message to a moderator

Re: ORA-1653: unable to extend table by 8192 in tablespace [message #475819 is a reply to message #475817] Fri, 17 September 2010 17:19 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>How much space exactly should I allocate if get rid of the error
At least 8192, but answer depends upon how much data you are trying to add to DB

Report message to a moderator

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
John Watson
Messages: 8932
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.

Report message to a moderator

Previous Topic: upgrade from 11.2.1 to 11.2.2.0
Next Topic: ORA-04043 resulting while quering user_views
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun May 19 19:08:56 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.