Trivia question - file date.

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Tue, 26 Nov 2002 10:17:51 -0000
Message-ID: <E2F6A70FE45242488C865C3BC1245DA702F9B48B@lnewton.leeds.lfs.co.uk>

Assuming Unix, then ls -l shows the last modification date/time, not the creation date/time.

As I don't use read only tablespaces, I always check I've got the right file to delete when I drop a tablespace by forcing a checkpoint, and checking the datafile dates - the one that I thought it was shouldn't have changed but the others should have. I then know that it is safe to remove the data file.

Measure twice, cut once - as Nuno would no doubt agree.

Why you have a file with an old date, and you don't have readonly tablespaces - I would suggest that the file is no longer part of the database.

Cheers,
Norman.

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com
-------------------------------------

-----Original Message-----
From: Daniel Morgan [mailto:dmorgan_at_exesolutions.com] Posted At: Tuesday, November 26, 2002 12:21 AM Posted To: server
Conversation: Trivia question - file date. Subject: Re: Trivia question - file date.

Joel Garry wrote:

> Todays trivia question:
>
> 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?
>
> (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.)
>
Received on Tue Nov 26 2002 - 04:17:51 CST