Re: Can I delete a datafile not used?

In <542jbo$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?
>
>Oracle7 v7.2.3 on AIX 4.1
>
>Thanks in advance.
>
>

Alberto,

It cannot be done, you will have to export your existing data and rebuild the entire tablespace if you want to remove the extra datafile.

Bye,
Steve

| any similarity 'tween my opinions and that |
|  of my employers are purely hypothetical   |
|     and should give no cause for alarm     |
 --------------------------------------------