Is it possible to make the initial size of imported table small

I don't think this is do-able, but I thought I would run it past y'all:

I am making a copy of a PROD schema using exp/imp, BUT, the initial extents are HUGE, can I somehow imp using a small initial size ?

why not create the schema prior to the import with the sizes you want and the import with ignore=y and just squirt the data in

I only need the objects created, not the data.

And ofcourse I can create them manually, and set the space the way I want it, but that is too much work ! If I can do it thru IMP.

Any other ideas, anyone.

Can the indexfile option help you ?

You can open the export file with hex editor and modify it (but be VERY careful).

next time export with COMPRESS=N

Oh man! I thought the COMPRESS option was a N by default; its 'Y'.
That will definitely help.

Thanks Pando.

Hey stancho,
Where can I get a HEX editor on UNIX ?
Never used one before.

Quote:

---

Originally posted by khussain
Hey stancho,
Where can I get a HEX editor on UNIX ?
Never used one before.

---

I haven't searched for such, my PC is Win2000, so I allways use UltraEdit, it is perfect for me. My colleague told me that dd is usefull :).

import show=y log=imp_x.log

just edit imp_x.log to get the create table statement and modify the initial, next whatever, the run the statement in sqlplus and import with ignore=y