Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> space problem

space problem

From: Swapna_P <Swapna_P_at_satyam.com>
Date: Thu, 3 Aug 2000 17:16:05 +0530
Message-Id: <10578.113719@fatcity.com>


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

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Dus-ascii">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>space problem</TITLE>
</HEAD>
<BODY>

<P><FONT COLOR=3D"#0000FF" FACE=3D"Arial">Hello,</FONT>
<BR><FONT COLOR=3D"#0000FF" FACE=3D"Arial">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.</FONT></P>

<P><FONT COLOR=3D"#0000FF" FACE=3D"Arial">And even though i =
find</FONT><B> <FONT COLOR=3D"#0000FF" FACE=3D"Arial">df -k = .</FONT></B><FONT COLOR=3D"#0000FF" FACE=3D"Arial">(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)</FONT></P>

<P><B><FONT COLOR=3D"#0000FF" =

FACE=3D"Arial">ptx/EFS:40:vTVERS:efs:vx_nospace:ees_information:/salary/= data file system full </FONT></B>
<BR><B><FONT COLOR=3D"#0000FF" FACE=3D"Arial">(2 block =
extent)ptx/EFS:40:vTVERS:efs:vx_nospace:ees_information:/salary/data = f</FONT></B>
<BR><B><FONT COLOR=3D"#0000FF" FACE=3D"Arial">ile system full (2 block =
extent)ptx/EFS:40:vTVERS:efs:vx_nospace:ees_information</FONT></B>
<BR><B><FONT COLOR=3D"#0000FF" FACE=3D"Arial">:/salary/data file system =
full (2 block extent)ptx/EFS:40:vTVERS:efs:vx_nospace</FONT></B>
<BR><B><FONT COLOR=3D"#0000FF" =

FACE=3D"Arial">:ees_information:/salary/data file system full (2 block = extent)ptx/EFS:40:vTVER</FONT></B>
</P>

<P><FONT COLOR=3D"#0000FF" FACE=3D"Arial">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.</FONT></P>

<P><FONT COLOR=3D"#0000FF" FACE=3D"Arial">TIA,</FONT>
<BR><FONT COLOR=3D"#0000FF" FACE=3D"Arial">Swapna</FONT>
Received on Thu Aug 03 2000 - 06:46:05 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US