-
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 ?
svk
-
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.
-
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|