Re: Trivia question - file date.

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)

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

Regards,

--
Roman Mirzaitov
Brainbench MVP for Oracle Administration
www.brainbench.com