Tablespace, Diskspace or sql abuse..

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Tue, 24 Jun 2003 16:11:35 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA703D3D9C3@lnewton.leeds.lfs.co.uk>

Hi Arcangelo,

Good call !!!

Cheers,
Norman.

---

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

-----Original Message-----
From: Arcangelo [mailto:arcangelo-c_at_yahoo.com] Posted At: Tuesday, June 24, 2003 3:11 PM Posted To: server
Conversation: Tablespace, Diskspace or sql abuse.. Subject: Re: Tablespace, Diskspace or sql abuse..

If this is 8i or above, then the use of tempfile temporary tablespace can
give rise to this error. When you create a tempfile datafile, Oracle only
'touches' the file, and doesn't actually map out and format the entire thing. If another file on the same disk grows into the space that the tempfile one day needs to properly format, then you get this sort of mess.

<SNIP> Received on Tue Jun 24 2003 - 10:11:35 CDT