Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to see if tablespace is autoextend?

Re: How to see if tablespace is autoextend?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 01 May 2003 11:36:44 +0800
Message-ID: <3EB0964C.16E0@yahoo.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US