Oracle-L: RE: table size.

From: Hately Mike <Mike.Hately_at_churchill.com>
Date: Mon, 08 Jul 2002 11:08:32 -0800
Message-ID: <F001.00491714.20020708110832@fatcity.com>

This is expected behaviour. COMPRESS=Y doesn't make reference to the amount of space occupied by rows, just the amount of blocks allocated to the object as a whole.
It's one of the great misunderstood parameters; really it should have been called COALESCE.
Richard's suggestion will probably work (depending on your INITIAL storage definition for that table).
Alternatively, pre-create the table at the required size before importing the table. Use IGNORE=Y on the import.

Also, a quick thought; if you really deleted 500 million rows, leaving 8 million behind it would have far quicker to copy those 8 million out and drop the table.

Regards,
Mike Hately

-----Original Message-----
Sent: 08 July 2002 18:59
To: Multiple recipients of list ORACLE-L

500 mill? How did you do your export? Try compress=n

-----Original Message-----
Sent: Monday, July 08, 2002 1:23 PM
To: Multiple recipients of list ORACLE-L

Hi all

I have a table with 8 millions rows and I deleted the 500 million. Then I exported tables (300 mb) and imported into another schema. After that, the table size is still the same.

I thought table size should be taken much less space. the storage clause for both table is the same: pct10,pctused 40.

any idea.

Mitchell

This email and any attached to it are confidential and intended only for the individual or
entity to which it is addressed. If you are not the intended recipient, please let us know
by telephoning or emailing the sender. You should also delete the email and any attachment
from your systems and should not copy the email or any attachment or disclose their content
to any other person or entity. The views expressed here are not necessarily those of
Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England.
Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP.

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Hately Mike
INET: Mike.Hately_at_churchill.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Mon Jul 08 2002 - 14:08:32 CDT