Home » RDBMS Server » Server Administration » How to allocate space for next extent whne no space hard disk.....
How to allocate space for next extent whne no space hard disk..... [message #193906] Tue, 19 September 2006 21:24 Go to next message
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



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 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
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 Go to previous message
oracledba_raja
Messages: 23
Registered: July 2006
Junior Member
Thanks, Mahesh.

Regards,
Raja
Previous Topic: Monitoring Full tablescans
Next Topic: Upgrade from Oracle9.0.1.0 to 9.2.0.7
Goto Forum:
  


Current Time: Fri Dec 02 12:45:28 CST 2016

Total time taken to generate the page: 0.09780 seconds