Home » RDBMS Server » Server Administration » datafile size
datafile size [message #55592] Mon, 03 February 2003 05:16 Go to next message
KK
Messages: 24
Registered: March 2002
Junior Member
Hi All,

How to find the exact size occupied in a particular datafile?

Regards,
KK.

Report message to a moderator

Re: datafile size [message #55593 is a reply to message #55592] Mon, 03 February 2003 05:22 Go to previous messageGo to next message
shareef
Messages: 72
Registered: November 2002
Member
select bytes/1024/1024 from v$datafile where name = 'prod';

hope its help

Report message to a moderator

Re: datafile size [message #55606 is a reply to message #55592] Tue, 04 February 2003 00:37 Go to previous message
Manish Deshmukh
Messages: 16
Registered: January 2003
Junior Member
Hello
You can query the table dba_data_files for the exact
tablespace wise sizing of datafiles.And in the table
dba_free_space u will number of bytes free tablepspace
wise.
Manish

Report message to a moderator

Previous Topic: Didicated Server and Shared Server
Next Topic: ORA-01653 error
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 23:10:44 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.