Is it possible to make the initial size of imported table small
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

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

  1. #1
    Join Date
    Sep 2000
    Location
    Chicago, IL
    Posts
    316

    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 ?

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    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

  3. #3
    Join Date
    Sep 2000
    Location
    Chicago, IL
    Posts
    316
    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.

  4. #4
    Join Date
    Jul 2000
    Posts
    521
    Can the indexfile option help you ?
    svk

  5. #5
    Join Date
    Jul 2003
    Location
    Sofia, Bulgaria
    Posts
    91
    You can open the export file with hex editor and modify it (but be VERY careful).

  6. #6
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    next time export with COMPRESS=N

  7. #7
    Join Date
    Sep 2000
    Location
    Chicago, IL
    Posts
    316
    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.

  8. #8
    Join Date
    Jul 2003
    Location
    Sofia, Bulgaria
    Posts
    91
    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 .

  9. #9
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    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
  •  



Click Here to Expand Forum to Full Width