import is taking too much space
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: import is taking too much space

  1. #1
    Join Date
    Nov 2000
    Posts
    6

    Hello,

    I have a user export dump of 9 MB of oracle 7.3.4 on SCO-UNiX.When I try to
    import into a exportor's default tablespace,it occupies the space of 500 Mb+
    200MB of index tablespace.but if I import into importer's default tablespace
    import takes the space of 1.3GB.

    Why it should be so.Import on both tablespaces are working fine.

  2. #2
    Join Date
    Mar 2001
    Location
    Ireland/Dublin
    Posts
    684
    That is interesting!
    How big is this tables in the tablespace?
    What are default parameters for tables/ablespaces?
    Did you make the option compress=y when you made an export?


    [Edited by kgb on 08-07-2001 at 06:28 AM]

  3. #3
    Join Date
    Nov 2000
    Location
    New Delhi, India
    Posts
    81

    Wink

    Try these
    Check if the import stops for long time at
    some table while importing
    Check the storage parameters of those imported tables.
    Correct them if necessary in the original tables and then
    make a fresh export dump using "Compress=Y"

    Hope it wrks

    Regards
    Shruti

  4. #4
    I think compress=y is also the default if unspecified.

    I actually had an import that failed because of this.

    When set to compress=n the import worked.

    It seems the initial extent it was creating was too big. It doesn't seem like this parameter would affect the problem you are having but it can't hurt to try .

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