OraFAQ Forum: Server Administration » Extents Probelm ( Very Urgent )

Home » RDBMS Server » Server Administration » Extents Probelm ( Very Urgent )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Extents Probelm ( Very Urgent ) [message #112963]

Wed, 30 March 2005 03:35

sridcpp
Messages: 23
Registered: February 2005
Location: India

Junior Member

I have a local tablespace tbs1 of 100mb

tbs1 tablespace is default tablespace to user1 with unlimited quota

in tbs1 tablespace only 10% of the space is used

when heavy dml's are going on ..on a particular table...it prompts an error...unable to extent....

eventhough there is lot of space in the tablespace, and unlimited quota on tbs1..why are we getting the error..

thanks in advance...

Report message to a moderator

Re: Extents Probelm ( Very Urgent ) [message #112978 is a reply to message #112963]

Wed, 30 March 2005 05:39

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Please post the complete error message, oracle version, tablespace ddl and table ddl.

Report message to a moderator

Re: Extents Probelm ( Very Urgent ) [message #113009 is a reply to message #112963]

Wed, 30 March 2005 09:23

bmahireddy
Messages: 14
Registered: March 2005

Junior Member

If the dml is occuring in a loop and if it's being commited only at the end, there is a possibility that the undo/rollback tablespace must be getting full.

Report message to a moderator

Re: Extents Probelm ( Very Urgent ) [message #113018 is a reply to message #113009]

Wed, 30 March 2005 10:29

sunil_v_mishra
Messages: 506
Registered: March 2005

Senior Member

hi

hey if u r inserting in table ..and max extent of that table is full .. then u have to change storage clause for that table which uses your tablespaces tbs1 (i.e datafile attached with tbs1).

SQL>ALTER TABLE <table name> STROAGE (MAXEXTENTS UNLIMITED);

i had given u some solution without knowing error number so Please post the complete error message, oracle version .. to get better solution....

regard
sunil

Report message to a moderator

Re: Extents Probelm ( Very Urgent ) [message #113030 is a reply to message #112963]

Wed, 30 March 2005 12:24

smartin
Messages: 1803
Registered: March 2005
Location: Jacksonville, Florida

Senior Member

Depending on details of your situation, could also be running out of space in your TEMP tablespace. That or UNDO would be my guesses, assuming your tablespace did in fact have enough room for all of your tables AND indexes and other objects being referenced. And of course assuming you are uniform extent size with a size less than the remaining space in tablespace.

Report message to a moderator

Re: Extents Probelm ( Very Urgent ) [message #113147 is a reply to message #112963]

Thu, 31 March 2005 03:46

sridcpp
Messages: 23
Registered: February 2005
Location: India

Junior Member

This was an interview question.

i had given the similar answer, making the maxextents unlimited, but the interviewer says..its already and local tablesapce with unlimited quota on which the table is residing.

Still he was not convincing..

Report message to a moderator

Previous Topic:	Database Link - which TNSNAMES file?
Next Topic:	drop and create a temporary tablespace

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Jan 25 03:32:33 CST 2025