RE: import size problem ???

Create the objects prior to the import, using sane values for INITIAL, NEXT, and MINEXTENTS.

> -----Original Message-----
> From: leslie.y.lu [mailto:leslie_y_lu_at_yahoo.com]
> Sent: Monday, August 06, 2001 11:07 AM
> To: ORACLE-L
> Cc: leslie.y.lu
> Subject: import size problem ???
>
>
> Hi all,
>
> I have an export file of 6M. The import file only has
> DDL. I imported the file into a db of about 1G.
> After import, the db became 6G !!! There is one table
> with 71 columns, but NO DATA, takes 1.8G !!!
> How does this happen, and how to make the objects
> claim the space. I issued Alter Table ... Deallocate
> Unused, but doesn't help. Also how to prevent this
> from happening.
>
> Both the export and import database are 815 on Sun5.6.
> The export db has 8K block size, while import db has
> 2K. Here is the par file:
>
> USERID=arbor/arbor123
> FROMUSER=ARBOR
> TOUSER=ARBOR
> COMMIT=TRUE
> IGNORE=TRUE
> FILE=arbor_full_20010726.dmp
> LOG=Afull.log
>
> Thank you!
>
> Leslie
>
> __________________________________________________
> Do You Yahoo!?
> Make international calls for as low as $.04/minute with
> Yahoo! Messenger
> http://phonecard.yahoo.com/
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Leslie Lu
> INET: leslie_y_lu_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: gregory.t.norris_at_mail.sprint.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).