Re: Packing tables/indexes

From: Yuk Hon Johnny Chan <jychan_at_corp.hp.com>
Date: 1995/10/07
Message-ID: <454he6$ld0_at_hpcc48.corp.hp.com>#1/1

Tom Reifinger (tomr_at_postoffice.ptd.net) wrote:
: I know that export import will compress tables/indexes to 1 extent,
: but how exactly do you get the table/index to drop unused blocks
: due to data deletion?

currently, the only way to do this is to export the table, truncate it, and re-import.

in V7.3, there is some feature to release unused space in a table, though I don't have any extensive info on this functionality.

Johnny Chan
Independent Oracle Specialist Received on Sat Oct 07 1995 - 00:00:00 CET

This message: [ Message body ]
Next message: Nick Todd: ""Oracle Developer" newsletter. Any views?"
Previous message: RZuniga: "Problem with new ODBC driver"
In reply to: Tom Reifinger: "Packing tables/indexes"
Next in thread: Stefan Benteler: "Re: Open Letter to Oracle re Linux (pls read and follow if you agree)"
Reply: Tom Reifinger: "Re: Packing tables/indexes"

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

Original text of this message