DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2000
    Hello friends,
    I need to load data from a temporary table I created as a result of loading data from a text file to a real production table which I still need to create. This new production table won't grow, i.e. no inserts, no updates expected.
    I am thinking about creating just one extent equal to the size of my temporary table. That case I'll use my storage efficiently.
    How do I estimate the size of the extent I need? I already analyzed my temp table. Would it be avg_row_len*num_rows?
    Any suggestions welcome.
    Thank you.

  2. #2
    Join Date
    Jun 2000
    average row length in bytes * num rows will give you an estimate of how many bytes the table is. you'll probablly want to create it with a bit more space for safety and possible unforseen updates but in general that will give you a good estimate.

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.