RE: import oddity

> -----Original Message-----
> From: Dennis Taylor [mailto:ismgr_at_pctc.com]
>
> I'm trying to do an import into a database. I've done this
> before, and it's
> always worked. Now it's failing with an error 1658 on a
> particular table.
> Teh error text includes this:
>
> "pctfree 10 pctused 40 initrans 1 maxtrans 255 storage
> (initial 1274224640
> next 637075456 minextents 1 maxextents 121" ... etc..
>
> To my inexperienced eye, it looks like the import is trying
> to create the
> table with an initial size of 1.3 GB or so. The table is
> *not* that big. I
> think it's around 200MB at most. As my tablespace datafiles
> are only 1GB
> each, I can see why the create fails (assuming I'm not
> misunderstanding
> everything).
>
> Is there anything I can do to tell the import not to create
> the table this
> big? Or to tell the database not to? Or other alternatives?

Did you say COMPRESS=Y on the export? That will cause the import to create an initial extent large enough to contain all the data in the table.

You can pre-create the table with more appropriate storage parameters and import with IGNORE=Y. Or, if you're feeling bold, you could try to edit the export file directly and change the "initial 1274224640" to something like "initial 0020971520" (20MB), but I personally wouldn't recommend that, and I've never tried it. Received on Fri May 18 2001 - 19:51:40 CDT