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_at_yahoo.com>
Date: Sat, 17 Jul 1999 14:25:55 +0800
Message-ID: <379021F3.60EA_at_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 - 08:25:55 CEST