OraFAQ Forum: Server Administration » How to allocate space for next extent whne no space hard disk.....

Home » RDBMS Server » Server Administration » How to allocate space for next extent whne no space hard disk.....

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

How to allocate space for next extent whne no space hard disk..... [message #193906]

Tue, 19 September 2006 21:24

oracledba_raja
Messages: 23
Registered: July 2006

Junior Member

Hi All,
Good Morning.

Scenario:

tabelspace A's size is 200MB.
The datafile size is 180 MB.
As the next extent size is 30MB, it is unable to allocate space for next extent.

For this,
can - Add one more datafile.

But no space in harddisk and can't get harddisk for next 5 hrs.

I suggest to decrease the extend size.

Is there anyother solution to this.

Actually what is the right method to over come this?

Thanks.

Raja

Report message to a moderator

Re: How to allocate space for next extent whne no space hard disk..... [message #193909 is a reply to message #193906]

Tue, 19 September 2006 21:28

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

Senior Member
Account Moderator

Nothing much.
Either stop inserting/updating data
or
Add more storage.
YOu can scrap some space here and there by rebuilding the tables/indexes, compressing them or archiving the old data away.
But whatever you do, it is a temporary fix.

[Updated on: Tue, 19 September 2006 21:31]

Report message to a moderator

Re: How to allocate space for next extent whne no space hard disk..... [message #193914 is a reply to message #193906]

Tue, 19 September 2006 21:48

oracledba_raja
Messages: 23
Registered: July 2006

Junior Member

Thanks, Mahesh.

Regards,
Raja

Report message to a moderator

Previous Topic:	Monitoring Full tablescans
Next Topic:	Upgrade from Oracle9.0.1.0 to 9.2.0.7

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 09:28:00 CDT 2024