Home » RDBMS Server » Server Administration » Freespace in LMT's ?
Freespace in LMT's ? [message #59587] Fri, 05 December 2003 03:05 Go to next message
Marks
Messages: 11
Registered: February 2002
Junior Member
How can you tell how much free space there is in a Locally managed tablespace (oracle8)?
I know about v$tempfile and dba_temp_files but they don't seem to provide the info.

Report message to a moderator

Re: Freespace in LMT's ? [message #59589 is a reply to message #59587] Fri, 05 December 2003 05:45 Go to previous message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
you mean for temporary tablespaces ?
Use v$temp_space_header

-Thiru

Report message to a moderator

Previous Topic: Help!!!Recover datafile that has been drop offline
Next Topic: Re-Ora 27123
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Sep 13 19:34:27 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.