RE: File size

An oracle datafile?
Then:

SQL> desc dba_data_files;

 Name                                      Null?    Type
 ----------------------------------------- --------


----------------------------

 FILE_NAME                                          VARCHAR2(513)
 FILE_ID                                            NUMBER
 TABLESPACE_NAME                                    VARCHAR2(30)
 BYTES                                              NUMBER
 BLOCKS                                             NUMBER
 STATUS                                             VARCHAR2(9)
 RELATIVE_FNO                                       NUMBER
 AUTOEXTENSIBLE                                     VARCHAR2(3)
 MAXBYTES                                           NUMBER
 MAXBLOCKS                                          NUMBER
 INCREMENT_BY                                       NUMBER
 USER_BYTES                                         NUMBER
 USER_BLOCKS                                        NUMBER=20

Otherwise...no clue.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Walid Alkaakati Sent: Tuesday, December 07, 2004 10:22 AM To: oracle-l digest users
Subject: File size

=20
How are you List !

Can you help Please ?

I need to know how to get the size of a file from pl/sql >

Thanks to your help>
--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Tue Dec 07 2004 - 09:30:05 CST