Did you coalesce the table space?
ALTER TABLESPACE ??? COALESCE
kwall7904_at_hotmail.com (DK15798) wrote in message news:<9acfd9f2.0303191817.795f96fc_at_posting.google.com>...
> 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.
Received on Thu Mar 20 2003 - 19:38:48 CST
