Results 1 to 2 of 2

Thread: Estimate space

  1. #1
    Join Date
    Dec 2002
    Posts
    5

    Angry Unanswered: Estimate space

    Somebody knows how can I estimate the size of a table and his index (PK, IX) with a number of records?. For example, in SyBASE we have sp_estspace to estimate the space but in Oracle I don't know how do it.

    SRR.

  2. #2
    Join Date
    Nov 2002
    Location
    Desk, slightly south of keyboard
    Posts
    697
    Google for "estimate oracle table size" there are plenty of scripts out there in the wild.

    Google result 1 of about 24,000
    http://www.dbaoncall.net/references/...able_size.html

    hth
    Bill

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •