datafile max size [message #267555] |
Thu, 13 September 2007 12:58  |
thorin666
Messages: 144 Registered: March 2007
|
Senior Member |
|
|
i have another problem 
i have a datafile and i want to know the "maxsize", i saw v$tablespace and v$datafile and i didn't find that value
where can i get it?
thnx in advance
|
|
|
Re: datafile max size [message #267562 is a reply to message #267555] |
Thu, 13 September 2007 13:03   |
TLegend33
Messages: 203 Registered: March 2005
|
Senior Member |
|
|
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
ONLINE_STATUS VARCHAR2(7)
[Updated on: Thu, 13 September 2007 13:04] Report message to a moderator
|
|
|
|
|
|