Re: How to get the autoextend size?

From: Connor McDonald <mcdonald.connor.cs_at_bhp.com.au>
Date: Wed, 20 Jan 1999 16:46:47 +0800
Message-ID: <36A597F7.D6C@bhp.com.au>

Stephanie Wood wrote:
>
> What table or view do I query to find out the autoextend size
> that is set on a datafile? I know that I can find this through
> the GUI storage manager. But I'd like to do it via
> SQL*PLUS. I have both Oracle 8.0.5 and 7.3.2 running.
>
> Thanks!
> Stephanie

In Oracle 8 you can get it in DBA_DATA_FILES In Oracle 7 its a little more hidden - join V$DATAFILES with SYS.FILEXT$ on file#. If SYS.FILEXT$ does not exist, then no datafiles are currently in autoextend mode..

HTH
--

---

Connor McDonald
BHP Information Technology
Perth, Western Australia
"The difference between me and a madman is that I am not mad"

• Salvador Dali

Received on Wed Jan 20 1999 - 02:46:47 CST