Try using "lslv <raw logical volume>" at the unix prompt . Here's an example:
Then just do some math: size=(PP SIZE)*(PPs) in this case size=(16megs)*(8)=128megs
Dear All,
Could someone help me to find out the file size on raw device. I ahve to attach few empty raw device files into tablespace but I don't know the actual size.
For example, crw-r--r-- 1 oracle dba 161,99013 Mar 6 14:48 mydb2_data100.dbf crw-r--r-- 1 oracle dba 161,99012 Mar 6 14:48 mydb2_data101.dbf
There are more than 20 files. I can't do trial & error to find out the size.
Any help would be really appreciated.
Thanks Sami
---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------
---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------