Re: CONFESSION TIME. -- large file on NT

"Hemant K Chitale" <hkchital_nospam_at_singnet_nospam.com.sg> wrote in message news:a6alpm$4b$1_at_violet.singnet.com.sg...
>
> Niall,
>
> See Bug # 1668488 on NT
> --- issue is with AutoExtend OR Resize when
> the size is at the 4GB boundary. Workaround :
> specify 1MB more or less than 4GB.
>
> Never use boundary sizes.
> Even with 64-bit Oracle I set the maxsize
> of datafiles to 1900M or 2000M but not 2048M.
>
> My flames ?
> 1. Yes, use AutoExtend but ALWAYS hard-code
> the Maxsize (1900M or 2000M)

I have no comment, other than to say I didn't set this up just noticed the ludicrous tablespace with 12gb allocated and 400mb or so of data.

> 2. OEM . blah ! svrmgrl or sqlplus. Great scripting
> language.

agreed but doesn't prtoect you from this one.
> 3. NT. Not worth talking about.

I know where you are coming from but disagree. (The db only actually contains 6gb of data NT can handle that.)

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************