Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> more space is occupied when imported even without rows
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.comReceived on Tue Mar 01 2005 - 01:12:56 CST
![]() |
![]() |