-
unable to extend index|table by 64000...
Can someone help. I am running an oracle 8.1.7 on Linux.
In one of my tablespaces, if I try to add a segment a following error occurs unable to extend ... by 64000. The initial extent is set to 1M then next extent is set to 1M the pctincrease is set to 0. For example if I create a table "create table xxx (num number) storage (initial 1M nextextent 1M pctincrease 0) tablespace bad_ts" then still the before mentioned error occurs. The tablespace is managed by dictionary. It happens only in bad_ts.
Thanks for your help ...
RR
-
Hi ,
The problem you are getting is due to max extent reached i.e tablespace fully occupied there is space left for new object to be created,enable auto extend of the file that belongs to tablespace or add one more datafile to the tablespace.
J Gangadhar
-
Ur TS has reached to its MAXEXTENTS.
Resize the datafile or add new datafile to that TS. I am not in favour of having autoextend option.
vishal sood
OCP 8
-
Originally posted by vishal sood
I am not in favour of having autoextend option.
I sense an interesting discussion -- why don't you favour it?
-
because by allow "auto-extend" u could potentially hit maximum datafile OS size limit 2GB for a single datafile in 32bit OS if i am not wrong?
-
Originally posted by vishal sood
I am not in favour of having autoextend option.
using that in production since Oracle 7.3.4
no problems whatsoever
-
Originally posted by ngwh
because by allow "auto-extend" u could potentially hit maximum datafile OS size limit 2GB for a single datafile in 32bit OS if i am not wrong?
there is this parameter called MAXSIZE
-
why you guys are talking about maxextents? where in the error says it reached maxextents...? it says it cannot extend!
-
ohh..u mean if auto-extend is ON .. for version 7.3.4 onwards ORACLE itself will create a new datafile once file size limit has been reached? interesting...hee
-
Though it is(Autoextend) very useful feature but what I mean to say is, if we use Autoextend option the Oracle will itself extend the size of datafile after reaching MAXEXTENTS. If someone(lazy DBA) never checks the used/free space related things then one day he may find that the datafile has been ocupied/extended up to the whole avaialble space.
vishal sood
OCP 8
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|