Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: How to see if tablespace is autoextend?
Peter wrote:
>
> Which table should I query if I want to see if a tablespace is set to
> autoextend? I could not find relevant information in v$datafiles or
> dba_data_files.
> Thanks
Its is dba_data_files on later versions, for ver 7 you need to check
SYS.FILEXT$
hth
connor
-- ========================= Connor McDonald http://www.oracledba.co.uk "Some days you're the pigeon, some days you're the statue"Received on Wed Apr 30 2003 - 22:36:44 CDT