Since it is raw, you have to use the lvm/fdisk/format command to know its size. Detailed command name depend on your os and lvm type. If you have added it as the dbfile, simply query the v$datafile/dba_datafiles, or use dbfsize command. ----- Original Message ----- From: <jaysingh1@xxxxxxxxxxxxx> To: <oracle-l@xxxxxxxxxxxxx> Sent: Tuesday, March 09, 2004 7:05 AM Subject: How to find out the file size o raw device? > 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 -----------------------------------------------------------------