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: more space is occupied when imported even without rows

Re: more space is occupied when imported even without rows

From: Richard Foote <richard.foote_at_bigpond.nospam.com>
Date: Tue, 01 Mar 2005 10:47:47 GMT
Message-ID: <nLXUd.180092$K7.115356@news-server.bigpond.net.au>


"Deepa balu via OracleMonster.com" <forum_at_OracleMonster.com> wrote in message news:1dca85444d2043fbbc19317af79b32e9_at_OracleMonster.com...
>
> Hi i have taken an export Dump of a full Database without rows option.
>
> exp system/manager file=fulldb.dmp full=y grants=y rows=n
>
> now i am trying to import objects of one user. The tablespaces are already
> created.
>
> imp geneva_admin/geneva_admin file=fulldb.dmp fromuser=GENEVA_ADMIN
> touser=GENEVA_ADMIN rows=n grants=y ignore=y
>
> 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?
>
> create tablespace customer_tab_ts_1 datafile
> '/u02/oradata/GEN35C/custdat01.dbf' size 400M autoextend on
> default storage (
> initial 256k
> next 256k
> pctincrease 0
> );

Hi Deepa,

Have you queried DBA_SEGMENTS to see what's inside the tablespace and how much space each segment has occupied ? Might be worth a peep.

Cheers

Richard Received on Tue Mar 01 2005 - 04:47:47 CST

Original text of this message

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