Message-Id: <10578.113719@fatcity.com> From: Swapna_P Date: Thu, 3 Aug 2000 17:16:05 +0530 Subject: space problem This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01BFFD40.63EC9610 Content-Type: text/plain Hello, Every month end after we run our production we execute a set of sqls for various purposes like for eg to generate reports,the report sizes are usually pretty huge. And even though i find df -k .(space check) to be sufficient it comes out saying a lot like this...(am i over looking something?? i might since iam new into DBA side) ptx/EFS:40:vTVERS:efs:vx_nospace:ees_information:/salary/data file system full (2 block extent)ptx/EFS:40:vTVERS:efs:vx_nospace:ees_information:/salary/data f ile system full (2 block extent)ptx/EFS:40:vTVERS:efs:vx_nospace:ees_information :/salary/data file system full (2 block extent)ptx/EFS:40:vTVERS:efs:vx_nospace :ees_information:/salary/data file system full (2 block extent)ptx/EFS:40:vTVER can anybody through some light on this or can u suggest a more useful solution than deleting the files and cleaning up the used path everytime. TIA, Swapna ------_=_NextPart_001_01BFFD40.63EC9610 Content-Type: text/html Content-Transfer-Encoding: quoted-printable space problem

Hello,
Every month end after we run = our production we execute a set of sqls for various purposes like for = eg to generate reports,the report sizes are usually pretty = huge.

And even though i = find df -k = .(space check) to be = sufficient it comes out saying a lot like this...(am i over looking = something?? i might since iam new into DBA side)

ptx/EFS:40:vTVERS:efs:vx_nospace:ees_information:/salary/= data file system full
(2 block = extent)ptx/EFS:40:vTVERS:efs:vx_nospace:ees_information:/salary/data = f
ile system full (2 block = extent)ptx/EFS:40:vTVERS:efs:vx_nospace:ees_information
:/salary/data file system = full (2 block extent)ptx/EFS:40:vTVERS:efs:vx_nospace
:ees_information:/salary/data file system full (2 block = extent)ptx/EFS:40:vTVER

can anybody through some = light on this or can u suggest a more useful solution than deleting the = files and cleaning up the used path everytime.

TIA,
Swapna