Re: Import taking up too much room with local managed tablespace

go to the following link and have a read of this, Your extent size is most likely way to big for the data you have

http://otn.oracle.com/deploy/availability/pdf/defrag.pdf

if it is for general testing  and not much data you could use 128k extents for everything but if it is for a production system then you will need to do your homework

--
=================================================
Peter McLarty               E-mail: Peter.Mclarty_at_mincom.com
Technical Consultant        WWW: http://www.mincom.com
APAC Technical Services     Phone: +61 (0)7 3303 3461
Brisbane,  Australia        Mobile: +61 (0)402 094 238
                            Facsimile: +61 (0)7 3303 3048
=================================================
A great pleasure in life is doing what people say you cannot do.

    - Walter Bagehot (1826-1877 British Economist)
=================================================
Mincom "The People, The Experience, The Vision"

=================================================









"Conrad, Ben" <BConrad_at_uspowersolutions.com>
Sent by: root_at_fatcity.com
18/01/2002 04:05 AM
Please respond to ORACLE-L



        

        To:        Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>

        cc:        

        Fax to:        

        Subject:        Import taking up too much room with local managed tablespace



Hi, 
I created a tablespaces in a test database to be locally managed with an extent size of 20544K.  A normal database import usually will fill a datafile with 5.8GB of data (on a dictionary managed tblspace) but with the local it has run out of space with the (2) 6GB files that I allocated to it.  I noticed that during the import the datafiles were filling up quite fast (too fast).  Data file 1 was filling up about 4x as fast as data file 2 during the import.
Why did this happen?  FYI, I have the compress=y set on the export if that makes any difference. 
Thanks, 
Ben. 

____________________________________ 
Benjamin Conrad 
Sr. Network Administrator 
USPowerSolutions 
mailto:bconrad_at_uspowersolutions.com 
617.547.3800 x195 
____________________________________ 



This e-mail communication and any attachments are confidential and intended only for the use of the designated recipients named above.  If you are not the intended recipient, you are hereby notified that you have received this communication in error and that any review, disclosure, dissemination, or distribution of it or its contents is prohibited.  If you have received this communication in error, please notify USPowerSolutions Corporation immediately by telephone at (617)547-3800 or via e-mail at ops_at_uspowersolutions.com and destroy all copies of this communication and any attachments. 




-- 
This transmission is for the intended addressee only and is confidential information.  If you have received this transmission in error, please delete it and notify the sender.  The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise.