Re: How to tell if autoextend is set on for a datafile

Peter Shankey wrote:
>
> I'm sorry I should have said that this is a 7.3 database. I did find
> all the info for a 8.0 and above.
>
>
> "Howard J. Rogers" wrote:
>
> V$datafile will show you the difference between what each
> datafile was
> created at, and what it is currently sitting at (so it will
> show you the
> effect of manual re-sizing, too).
>
> But the real view you're after is dba_data_files, which has
> a column headed
> "AUT" (ie, 'autoextensible'), as well as columns for
> Maxbytes and Maxblocks,
> plus one for 'Increment By' -ie, the 'next' parameter in the
> autoextend
> clause.
>
> Regards
> HJR
> --
> --------------------------------------------------------------------------
>
> Opinions expressed are my own, and not those of Oracle
> Corporation
> Oracle DBA Resources:
> http://www.geocities.com/howardjr2000
> --------------------------------------------------------------------------
>
> "Peter Shankey" <shankeyp_at_charlestoncounty.org> wrote in
> message
> news:39DFC090.7AED81C0_at_charlestoncounty.org...
> > What view shows where or not autoextend is set for a data
> file and what
> > the various values are?
> >
> > Thanks
> > Pete
> >
>
> --
> Pete Shankey
>
> shankeyp_at_charlestoncounty.org
>
>

sys.filext$

(If this table is not there, then nothing is in autoextend mode)

HTH

-- 
===========================================
Connor McDonald
http://www.oracledba.co.uk
(faster/mirrored at http://www.oradba.freeserve.co.uk)

Its not the voices in my head that bother me... 
  its the voices in yours.