Re: more space is occupied when imported even without rows

On Tue, 01 Mar 2005 07:12:56 GMT, "Deepa balu via OracleMonster.com" <forum_at_OracleMonster.com> wrote:

>But i can literally see the tablespace has grown up to around 2 GB but i can say the objects alone cannot occupy so much space.
>
>what will be the problem?

Not posting version
(Probably) not using locally managed tablespaces Using compress=Y (which is the default).This will recreate the object in one large extent, equal in size to all original extents, and a new next_extent of 10 percent of the size of the new initial extent.

--
Sybrand Bakker, Senior Oracle DBA