Re: Oracle Table Space
From: <satar_at_my-dejanews.com>
Date: Tue, 01 Dec 1998 23:45:14 GMT
Message-ID: <741v29$btv$1_at_nnrp1.dejanews.com>
Date: Tue, 01 Dec 1998 23:45:14 GMT
Message-ID: <741v29$btv$1_at_nnrp1.dejanews.com>
No such thing. A table resides in the datafile(s) that associate with the tablespace.
So think about it. You have a tablespace called "Users". The datafile 'user01.dbf' is 200MB. The only table that sits in that tablespace is 100MB. You do a 'ls -l' on 'user01.dbf' , it will still show 200MB.
Good Luck,
Satar
In article <366542dd.107435904_at_news.pwgsc.gc.ca>,
NeedaHoliday wrote:
> Does anyone know the Unix command to determine how much space a table
> has used.
>
-- Oracle DBA/UNIX System Admin Advanced Enterprise Solutions (949) 756-0588 Oracle Re-Seller -----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your OwnReceived on Wed Dec 02 1998 - 00:45:14 CET