Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Determine avilable free space

Status
Not open for further replies.
rohanem

rohanem

Programmer
Aug 16, 2002
64
0
0
US
Hi,
Can anyone tell me how to determine how much space is left on a particular partition in a table? I want to setup an automatic "alerting" method when the space is nearing 0

Thanks
 
Sort by date Sort by votes
Hi
to AskTom.Oracle.com and do a search on 'free_space' he has an excellent procedure to do this.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

kernal
  • Locked
  • Question
Extract string before the first "-" it finds and the space prior to the "-"
Replies
5
Views
71
carp
carp
kernal
  • Locked
  • Question
Extract after and between spaces in a string 1
Replies
1
Views
44
johnherman
johnherman
Andrzejek
  • Locked
  • Question
TO_CHAR(Number, '000') and a Space 2
Replies
5
Views
141
ChrisHunt
ChrisHunt
runmd
  • Locked
  • Question
Determine Precision and Scale from a Numeric Column 1
Replies
3
Views
79
SantaMufasa
SantaMufasa
THoey
  • Locked
  • Question
SQL to determine locks 1
Replies
4
Views
22
SantaMufasa
SantaMufasa

Part and Inventory Search

Sponsor

Back
Top