Home » SQL & PL/SQL » SQL & PL/SQL » SQL Question
SQL Question [message #4471] Thu, 12 December 2002 10:19 Go to next message
newbie2
Messages: 8
Registered: October 2002
Junior Member
how do i query a database on windows 2000 to find all datafiles with a maximum disk space or max extent of unlimited?

Report message to a moderator

Re: SQL Question [message #4481 is a reply to message #4471] Fri, 13 December 2002 12:02 Go to previous message
Dhiren
Messages: 43
Registered: July 2002
Member
You can query on dba_data_files to get the size in
bytes for all your datafiles.
Max extents are in dba_tablespaces

Report message to a moderator

Previous Topic: duplicating records
Next Topic: Package Access
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 16 06:52:23 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.