Re: Can I delete a datafile not used?

In article <542j70$8fv_at_eccdb1.pms.ford.com> usfmd2ya_at_ibmmail.com (Alberto Rivera) writes:
>I make a mistake and add a datafile to a wrong
>tablespace.
>
>The datafile is not used by any segment because
>the tablespace already had enough free space with
>another datafiles.
>
>So I want to delete such datafile or assign it
>to the right tablespace. It's possible?

It appears whoever designed the "ALTER TABLESPACE" command decided that this would never happen, so there is no trivial way to drop a data file.

>
>Thanks in advance.
>

-- 
Joel Garry               joelga_at_rossinc.com               Compuserve 70661,1534
These are my opinions, not necessarily those of Ross Systems, Inc.   <> <>
%DCL-W-SOFTONEDGEDONTPUSH, Software On Edge - Don't Push.            \ V /
panic: ifree: freeing free inodes...                                   O