Hi here,
I'd just like to know whether you know how I could see
if a tablespace has been created with the AUTOEXTEND
option switched on or off... We have no scripts of the
tablespaces, so I'd like to know if some V$ views contain
this information about our tablespaces...

Thanks a lot for any help !

Regards,

Seb

Answer:

That's not the tablespace that is in autoextend mode
but the its datafiles.
You can get informations on file extensions in sys.filext$.

v734> desc sys.filext$
 Name                            Null?    Type
 ------------------------------- -------- ----
 FILE#                           NOT NULL NUMBER
 MAXEXTEND                       NOT NULL NUMBER
 INC                             NOT NULL NUMBER

--
Have a nice day
Michel