RE: File size

  • From: "Stephens, Chris" <ChrisStephens@xxxxxxx>
  • To: <Walid.Alkaakati@xxxxxxxxxxxxxxx>, "oracle-l digest users" <oracle-l@xxxxxxxxxxxxx>
  • Date: Tue, 7 Dec 2004 10:28:14 -0500

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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] 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>
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l

Other related posts: