Re: Q: DD view for autoextend properties

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Mon, 29 Mar 1999 09:41:00 -0800
Message-ID: <36FFBB2C.F7B4A44@us.oracle.com>

Uwe

As the others mentioned, you could use filext$ in earlier releases. Later releases (7.3?) added the columns AUTOEXTENSIBLE, MAXBYTES, MAXBLOCKS and INCREMENT_BY to DBA_DATA_FILES.

HTH. Pete

Uwe Schneider wrote:

> Hi,
>
> does anybody of know a data dictionary view which reveals the autoextend
> properties (my, unlimited...) of data files?
>
> Tnx
>
> Uwe
>
> --
> Uwe Schneider | Telefon +49 7251 / 82587
> Karlsdorfer Str. 31 | Mail pi_at_richard-schneider.de
> DE-76646 Bruchsal |
> Linux - OS al dente!

--

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 Mon Mar 29 1999 - 11:41:00 CST