Re: Finding AUTOEXETEND objects

Try sys.filext$

This view is created when you turn autoextend on for any datafile.

Doug Cowles wrote:

> I need to find things with AUTOEXTEND on.
> Oracle 7.3.3
> I also need to turn AUTOEXTEND off on these
> objects. I don't see an obvious column for
> autoextensibility. Not v$datafile, not dba_data_files,
> not dba_tablespaces.
>
> - Dc.
Received on Wed Mar 10 1999 - 11:38:25 CST