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

Home -> Community -> Usenet -> c.d.o.server -> Re: Reports 2.5 - IDX and DAT files

Re: Reports 2.5 - IDX and DAT files

From: Leng Kaing <lkaing_at_yahoo.com>
Date: Sun, 29 Aug 1999 18:19:57 +1000
Message-ID: <37C8ED2C.7C5EC069@yahoo.com>


Mark,

Yes, these are temporary files. It was just annoying to find them lying around in whatever directory we happened to be running them. Another person on the internet correctly stated that a registry entry REPORTS_TMP can be added to point to the equivalent of /tmp - eg. c:\temp.

Thanks,
Leng.

mgumbs_at_hotmail.com wrote:

> These temp files are created by Oracle Reports when it needs to sort
> data, the .dat file being your data and the .idx file being the sort
> order the output needs to be in.
>
> In unix, they are usually stored in /tmp and should delete themselves
> after the report is complete. However, if the report terminates
> abnormally, they will remain on disk.
> If the timestamp on these files are a few days old, it should be ok to
> delete them, or create some kind of cron or timed process to do it for
> you.
>
> Mark
>
> In article <37C3289B.5BC617AE_at_yahoo.com>,
> Leng Kaing <lkaing_at_yahoo.com> wrote:
> > Hi,
> >
> > I'm sure there is an expert among you guys.
> > I have this annoying problem with Report 2.5 reports.
> >
> > When running a Report 2.5 report, it automatically creates these
> > IDXnnnnnn and DATnnnnn files that were created ?
> > Is there an option to tell the Report 2.5 reports, to clean up it own
> > workfiles?
> >
> > Note: I'm not too sure what these files are... I'm pressuming these
> > files are the Report 2.5 's workfile.
> >
> > Thanks,
> > Leng.
> > leng.kaing_at_hancorp.com.au
> >
> >
>
> Sent via Deja.com http://www.deja.com/
> Share what you know. Learn what you don't.
Received on Sun Aug 29 1999 - 03:19:57 CDT

Original text of this message

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