Re: How to check datafile autoextend ON/OFF ?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Sat, 17 Jul 1999 14:25:55 +0800
Message-ID: <379021F3.60EA@yahoo.com>

Kevin Cheung wrote:
>
> Is there any view in data dict so that I can know whether a datafile
> autoextend is ON or OFF, and the max size if autoextend is ON.
>
> Kevin Cheung

In Oracle8 its there in dba_data_files

In Oracle7, look at sys.filext$ (if this does not exist, then none of your files are in autoextend mode)
--

---

Connor McDonald
"These views mine, no-one elses etc etc" connor_mcdonald_at_yahoo.com

"Some days you're the pigeon, and some days you're the statue." Received on Sat Jul 17 1999 - 01:25:55 CDT