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: Help needed : Free space checking?

Re: Help needed : Free space checking?

From: fumi <fumi__at_tpts5.seed.net.tw>
Date: 1998/12/07
Message-ID: <74ghnp$4rq$2@news.seed.net.tw>#1/1

Johan Nilsson ¼¶¼g©ó¤å³¹ <366baa0e.0_at_d2o19.telia.com>... [snip]
>However, if I delete several thousands of records and commits the changes,
>no difference in free space is seen? How is this??

Oracle does *NOT* release space after deleting records. Only TRUNCATE and DROP statements can free the space. Received on Mon Dec 07 1998 - 00:00:00 CST

This message: [ Message body ]
Next message: steve_young_at_my-dejanews.com: "loading first or create index first?"
Previous message: christina_cheung_at_iname.com: "Re: Help needed : Free space checking?"
In reply to: Johan Nilsson: "Help needed : Free space checking?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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