Re: Trivia question - file date.

"Roman Mirzaitov" <rmirzaitov_at_kt.kg> wrote in message news:<arvd9k$m7a48$1_at_ID-127142.news.dfncis.de>...
> Hi Joel,
>
>
> "Joel Garry" <joel-garry_at_home.com> wrote in message
> news:91884734.0211251437.2adfd4ec_at_posting.google.com...
> >
> > If you don't use read-only tablespaces, and you bounce your database
> > weekly, can you have a legitimate Oracle database file dated 6 months
> > old?
>
> my guess is no. Probably this is the old unused file.
>
> > (assuming 8.1.7 on unix, normal operations with no backup/restore in
> > progress, no funny business with "touch," Oracle handling the files,
> > not including stuff like installed files and logs.)
> >
> >
> > So I see a file among the data files with a 6 month old date. select
> > * from v$dbfile; not there. Oh wait, select tablespace_name,
> > contents from dba_tablespaces; almost missed the locally managed temp
> > file. Well, the temp file has a recent date, so the old one isn't
> > used, right? Oh wait, select * from dba_temp_files;
> >
>
> did you try
> select file_name from dba_data_files (describes database files)
> and
> select * from v$datafile? (datafile information from the control file)
>

Well, yes I did, until I realized v$dbfile was just as reasonable. They both don't deal with temp files. That's what dba_temp_files is for.

> What do they say? I think if there are no records about your file you can rm
> it easily.
>
> Regards,

Well, I'm not about to test that on my production database! :-)

jg

--
@home is bogus
First SBC/Pac Bell digs up a bunch of people's yards to test fiber. 
Then they cancel test and dig it back up because they want to push
copper DSL.  Now they complain that they can't compete with cable
companies' fiber.  Sheesh.