Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How Do You Empty A Datafile Without Being Able To Take The Database Offline
"DK15798" <kwall7904_at_hotmail.com> wrote in message
news:9acfd9f2.0212260928.351eb26c_at_posting.google.com...
> I have a space problem, and I need to dump some data from the
> datafiles (or something to free up some space). I am using Oracle 7.1
> Server on a Windows NT machine. This message has left out in-depth
> detail to avoid getting incorrect answers. I am looking for broad
> general suggestions. Thank you for your help.
Export the tables in that datafile (or tablespace if more than one datafile
in the tablespace), drop the tablespace, recreate it with a smaller size,
import the tables back. Oracle 7 doesn't have some of the newer features
that would make this easier.
Received on Fri Dec 27 2002 - 09:32:14 CST