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: [EMAIL PROTECTED] 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" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED] 18/01/2002 04:05 AM
|
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> 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:[EMAIL PROTECTED]
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 [EMAIL PROTECTED] 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.
