Problem Importing data

I have exported 2 schemas proddta (1.6 Gb) and prodctl (40 Mb) with compress=n. I truncate testdta and testctl schemas which have all same tables as prod schemas. When I attempt to import the data using fromuser=proddta touser=testdta, the tablespace blows out at 2.5 Gb and most of the large tables fail to import. This means that the total import would exceed approx double that of the source schema size. I have checked pctincrease and pctfree on a selection of the tables, particularly the larger tables. They appear to be the same as for the production schema. The only difference I can detect is that the initial and next are different but I would think that that would only change the number of extents and not the number of data blocks.

How can I get this import to resemble the prod data? Received on Tue Nov 21 2000 - 18:31:12 CST