Re: Datafile

Hi,

That is the right behaviour of the command. The Datafile does not vanish until you drop that tablespace. But for all Oracle's purposes that datafile does not exist. You can delete it from the OS

Johnson

• Ade Bankole <ade_ba_at_hotmail.com> wrote:
  > DBA's
  >
  > successfully used the following command to remove a
  > datafile -:
  >
  > alter database
  > datafile
  >
  'C:\ORACLE\ORADATA\ADE\DM_ADEPOJU_PLC081500_173534_DB3.DBF'
  > offline drop
  >
  > How come when i issue the following query for the
  > tablespace I can still see
  > an entry for the datafile -:
  >
  > SQL> select file_name from dba_data_files where
  > tablespace_name =
  > 'DM_ADEPOJU_PLC_DOCBASE';
  >
  > FILE_NAME
  >
  

  ---

  
  >
  C:\ORACLE\ORADATA\ADE\DM_ADEPOJU_PLC081500_173534_DB1.DBF
  >
  C:\ORACLE\ORADATA\ADE\DM_ADEPOJU_PLC081500_173534_DB2.DBF
  >
  C:\ORACLE\ORADATA\ADE\DM_ADEPOJU_PLC081500_173534_DB3.DBF
  >
  >
  > And when I qury v$datafile for the datafile i got
  > the following -:
  >
  > SQL> select status from v$datafile where
  >
  NAME='C:\ORACLE\ORADATA\ADE\DM_ADEPOJU_PLC081500_173534_DB3.DBF';
  >
  > STATUS
  > -------
  > RECOVER
  >
  > Please help.
  >
  >
  >
  >
  >
  >
  >
  

  ---

  
  > Get Your Private, Free E-mail from MSN Hotmail at
  > http://www.hotmail.com.
  >
  > Share information about yourself, create your own
  > public profile at
  > http://profiles.msn.com.
  >
  >
  > --------
  > Think you know someone who can answer the above
  > question? Forward it to them!
  > to unsubscribe, send a blank email to
  > oracledba-unsubscribe_at_LAZYDBA.com
  > to subscribe send a blank email to
  > oracledba-subscribe_at_LAZYDBA.com