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

more space is occupied when imported even without rows

From: Deepa balu via OracleMonster.com <forum_at_OracleMonster.com>
Date: Tue, 01 Mar 2005 07:12:56 GMT
Message-ID: <1dca85444d2043fbbc19317af79b32e9@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
);

-- 
Message posted via http://www.oraclemonster.com
Received on Tue Mar 01 2005 - 01:12:56 CST

Original text of this message

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