Re: Can I delete a datafile not used?

From: Paul Jackson <usfmcqwq_at_ibmmail.com>
Date: 1996/10/16
Message-ID: <326507EB.6052@ibmmail.com>#1/1

Alberto Rivera wrote:

>........

>
> 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.

Yes, BUT you will have to drop and recreate the tablespace and all objects within. You will need to export all objects on the tablespace, drop the tablespace, recreate the tablespace at the proper size then import the objects back into the tablespace. This is the only way I know how to do it but that doesn't mean that it is the only way.

Good Luck!

Paul Jackson paul_jackson_at_e-mail.com Received on Wed Oct 16 1996 - 00:00:00 CDT