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 ?
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.
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 :).Quote:
Originally posted by khussain
Hey stancho,
Where can I get a HEX editor on UNIX ?
Never used one before.
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