Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: DK15789: How do a reclaim space after deleting table data in a datafile

Re: DK15789: How do a reclaim space after deleting table data in a datafile

From: charlie cs <spam)_at_yahoo.com>
Date: Thu, 20 Mar 2003 02:42:02 GMT
Message-ID: <_T9ea.22459$SX.4605@nwrdny03.gnilink.net>


alter table move tablespace

"Ana C. Dent" <anacedent_at_hotmail.com> wrote in message news:cJ9ea.4485$Bq6.3560_at_fed1read02...
> DK15798 wrote:
> > I am running Oracle 7.3 server. I have three data files roughly
> > around a gig each. I have 200 tables inside the datafiles (in no
> > particular order). These tables are using around two gigs. I deleted
> > all contents (not the tables themselves) of the tables (while leaving
> > the actual empty tables there). When I view how much space is being
> > used by the datafiles, it is still two gigs. I can't figure out why.
> > I have deleted all the tables so that the datafiles report zero space
> > used, but when I import the data back in (just the empty tables) it
> > jumps back up to two gigs. note: I just delete all the tables(with a
> > script) I have not yet dropped the tablespace(and I would rather not
> > if possible). Can anybody help me with this, I would greatly
> > appreciate it. Thank you in advance.
>
> a DELETE does NOT move the table's High Water Mark.
> Try issuing a TRUNCATE TABLE command.
>
>
Received on Wed Mar 19 2003 - 20:42:02 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US