Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: remove a datafile.
Chris Lee wrote:
> I accidentially created an extra datafile for one of my
> tablespacess. I would like to know if there is any way I
> can remove that datafile.
Hi Chris,
you can export all objects in the tablespace in question
using the export-utilitiy (Documetation in Oracle
Utilities).
Then drop old Tablespace, create new tablespace and
import your data.
good luck
Hermann
Received on Wed Nov 29 2000 - 16:48:13 CST