drop datafile from tablespace

Hi,

(HP 9.x / Oracle 7.0/7.2)

a few days ago I add a datafile to an existing tablespace. It works fine and because it was only a test I want to drop/delete the datafile from the the tablespace. I don't know exactly the command, because I'm not in the office yet, but it was something like

alter tablespace <name> offline drop;

I got the message "Statement processed" but a "select * from dba_data_files" shows me, that the datafile was still there. But the physical file associated with the datafile was still deleted, so that I can't set the tablespace offline. Can someone give me a hint, what I have to do, if I wan't delete a datafile from the tablespace. Or is it right, that the datafile-entry appears on the select statement after dropping the datafile from tablespace ?

bye
 Frank

--


#   Frank Hoerper      51674 Wiehl		Tel.: +49 2262 - 68581

#   fh_at_wad.org (privat)				hoerper_at_uggk00.ug.eds.com 


#   crypt: PGP public key available



-- 


#   Frank Hoerper      51674 Wiehl		Tel.: +49 2262 - 68581

#   fh_at_wad.org (privat)				hoerper_at_uggk00.ug.eds.com 


#   crypt: PGP public key available