Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Deleting obsolete datafiles
> > I wonder if there is a way to drop an obsolete datafile,
> > without doing an export of the entire tablespace, delete the tablespace,
> > recreate the tablespace and import the data again.
Just nitpicking, but don't forget about
alter table .. move tablespace ...
alter index .. rebuild tablespace ...
instead of exp/imp
jan Received on Fri Nov 14 2003 - 15:47:54 CST