RE: Temporary Tablespace Problem

is the
datafile a tempfile for temp tablespace?  

  <FONT face=Tahoma
  size=2>-----Original Message-----From: Arslan Dar   [mailto:arslandar_at_skm.org.pk]Sent: Tuesday, November 13, 2001 1:30   AMTo: Multiple recipients of list ORACLE-LSubject:   Temporary Tablespace Problem
  Hi all,
  Is there a way to alter a TEMPORARY table   space to Logging from NoLogging. I issue the command,<FONT   face=Arial size=2>ALTER TABLESPACE TEMPORARY LOGGING;<FONT   face="Times New Roman"> The same command   holds good for every other tablespace except for Temporary. I need to this   because I wanted to setup the Standby database and was trying to copy the   datafiles from the primary site to the Standby site, Online. For that I had   put every tablespace in BEGIN BACKUP mode but Temporary couldn't be taken to   the Backup Mode becuase of its Nologging attribute. The work around is to   create another temporary tablespace and change every users default temporary   tablespace to the new one and then drop this one and create a new Temporary   file withthe same name. (or shutdown the database and then copy this file   tothe other system) THis I will do becuase of the entry in the control file   with the name for the Temporary tablespace.   But if there is a way the tablespace can be altered   to logging, it will save quite some time.   The tablespace is Locally Managed, and with   Uniform Storage allocation. (Oracle 8.1.7 on WINNT4)<FONT

  face="Times New Roman"> Regards<FONT 
  face="Times New Roman"><FONT face=Arial 
  size=2>HussainDBA<FONT 
  face=Arial size=2>SKMCH & RC