Import Question
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Import Question

Hybrid View

  1. #1
    Join Date
    Oct 2000
    Location
    Halifax, Nova Scotia
    Posts
    197
    Hello all

    I am trying to do an import of a SAP system that contains about 50,000 objects. I am not importing the rows just the object metadata. Any idea what size of a table space I should have. I exported without rows and ended up with a 47 Mb DMP file. Is there any way to tell by that for large the import will be.
    Don't be afraid to try something new. Amateurs built the Ark, professionals built the Titanic

  2. #2
    Join Date
    Oct 2000
    Location
    Cambridge, MA (Boston)
    Posts
    144
    In short, no.

    Do you know what parameters SAP used for the export (if you did it using SAPDBA)? If you can find out what the parameter were (i.e. OWNER=____ or TABLES=____ ). If you know what the objects are, you can check to see what size they are now. If they fit before in the tablespace(s), more than likely they'll fit again. I'm afraid I've been out of SAP too long to tell you how to check this, but I think SAP tells you a directory (randomly named) that it used for exp/imp activity during the operation.

    Check for whether the export used COMPRESS=N. If it didn't you could get the object sizes from the export file by importing with the parameter SHOWFILE and checking all the "initial extents." If this sounds tedious, it would be for 50K objects.

    Good luck, D.

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