Re: Urgent Help Needed!

Easy, tiger.... No need to start flaming... People like helping here.. To answer your question (I just popped on after being away for a week),

I assume you want the total space used by all files (temp & perm) in the database, not just in certain tablespaces.. If that is correct, then

	select round(sum(bytes)/1048576,2) "MB" from dba_data_files
	/

	select round(sum(bytes)/1048576,2) "MB" from dba_temp_files
	/

rwking_at_gmail.com wrote:
> I just joined, and I'm a student. I can't do much helping, however if
> it were possible for me to help someone, I definitely would, and I
> wouldn't waste their time. If you don't want to help me, then ignore
> me.
>
>
>
>
>
> IANAL_VISTA wrote:

>> rwking_at_gmail.com wrote in
>> news:1158201287.168809.285500_at_e63g2000cwd.googlegroups.com:
>>
>>> It's a public forum, sir.  I need help, and that's what these groups
>>> are for.
>>>
>>>
>>> IANAL_VISTA wrote:
>>>> rwking_at_gmail.com wrote in
>>>> news:1158200365.513368.306500_at_i3g2000cwc.googlegroups.com:
>>>>
>>>>> Hi everyone,
>>>>>
>>>>> I have a project due in about an hour... one of the questions I
>>>>> have to answer is determining the physical size of the database.
>>>>> It's an Oracle 10 database.  Actually, it's a small datawarehouse
>>>>> with 5 tables of raw data.  I only have a SQL Plus interface, so
>>>>> some commands don't work.  I can't find a query to get me the
>>>>> physical size anywhere on the net.  If you have any ideas or input,
>>>>> PLEASE send me an email or respond to this post.  I would greatly
>>>>> appreciate it.  I hope someone is out there.
>>>>>
>>>>> Regards,
>>>>>
>>>>> Rich
>>>>>
>>>>>
>>>> STOP cross/mutil-posting
>>>
>> So who are YOU helping today?