Re: Can I delete a datafile not used?

Alberto Rivera wrote:
>
> 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?
>
> Thanks in advance.

Alberto, there are a number of things you can try, but they are tricky and require a VERY GOOD understanding of how Oracle works, especially its control file information and a few other internals.

The best an safest way to do what you require is to:

. export all the data belonging to all users in the tablespace to

   which you mistakingly added the data file . recreate the tablespace without the data file . import all user data back

Michael  

###################################################################
# Michael Abbey           Ottawa ON Canada      613 780 2364
#
# Co-author of:   Tuning Oracle          Oracle: A Beginner's Guide
#                 Oracle Data Warehousing
###################################################################