Home » SQL & PL/SQL » SQL & PL/SQL » datafile max size
datafile max size [message #267555] Thu, 13 September 2007 12:58 Go to next message
thorin666
Messages: 144
Registered: March 2007
Senior Member
i have another problem Sad
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 Go to previous messageGo to next message
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

Re: datafile max size [message #267566 is a reply to message #267562] Thu, 13 September 2007 13:20 Go to previous messageGo to next message
thorin666
Messages: 144
Registered: March 2007
Senior Member
TLegend33 wrote on Thu, 13 September 2007 13:03
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)


thnx i didn't know about that table Very Happy
Re: datafile max size [message #267568 is a reply to message #267566] Thu, 13 September 2007 13:23 Go to previous messageGo to next message
TLegend33
Messages: 203
Registered: March 2005
Senior Member
It's a data dictionary view.
Re: datafile max size [message #267571 is a reply to message #267566] Thu, 13 September 2007 13:42 Go to previous message
Michel Cadot
Messages: 68733
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
i didn't know about that table

select * from dict order by 1;

Regards
Michel
Previous Topic: query on a result of another query
Next Topic: Append multiple results to single row
Goto Forum:
  


Current Time: Tue Feb 11 10:19:28 CST 2025