charlie cs wrote:
>
> 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.
> >
> >
might not work in 7.3 :-)
--
=========================
Connor McDonald
http://www.oracledba.co.uk
"Some days you're the pigeon, some days you're the statue"
Received on Thu Mar 20 2003 - 02:34:19 CST
