Re: Finding AUTOEXETEND objects

From: Peter Sharman <psharman_at_us.oracle.com>
Date: Wed, 10 Mar 1999 09:30:30 -0800
Message-ID: <36E6AC35.91473FD9@us.oracle.com>

Doug

Check FILEXT$ (or is it FILEEXT$?). Can't remember if there's an extra e or not.

HTH Pete

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.

Regards

Pete

Peter Sharman                             Email: psharman_at_us.oracle.com
WISE Course Development Manager           Phone: +1.650.607.0109 (int'l)

Worldwide Internal Services Education            (650)607 0109 (local)

San Francisco

SQL> select standard_disclaimer, witty_remark 2 from company_requirements;

Opinions are mine and do not necessarily reflect those of Oracle Corporation

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA

Received on Wed Mar 10 1999 - 11:30:30 CST