Hot backup/Tempfile Question

From: Chucky <chuck.carson_at_syrrx.com>
Date: Wed, 18 Dec 2002 07:44:59 -0800
Message-ID: <3E0097FB.6000607@syrrx.com>

Our DBA's have created several temporary files that are not listed in dba_data_files, but instead dba_temp_files.

My question is, when backing these up during a hotbackup, does it matter is they are being written to or not. I currently generate the SQL to recreate them using the same datafiles (with the REUSE clause). It it safe to copy these files during the hotbackup even though they may be in use?

Also, it listed the status of each of these temporary files as AVAILABLE, does this mean they are not being used, or they are? ie: what are the different values the STATUS can be?

Thx,
CC

-----------== Posted via Newsfeed.Com - Uncensored Usenet News ==----------

http://www.newsfeed.com The #1 Newsgroup Service in the World! -----= Over 100,000 Newsgroups - Unlimited Fast Downloads - 19 Servers =----- Received on Wed Dec 18 2002 - 09:44:59 CST