Table Creation
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Table Creation

  1. #1
    Join Date
    Sep 2001
    Location
    Pondicherry-India
    Posts
    33

    Question

    Hi guys


    We are trying to create a table in Oracle, which was already available in Foxpro.

    Table Size : 466 bytes
    No of Records : 75000 ( in 6 Yrs.)
    Current Size : 35 MB

    Yearly Increase in Size : 5 MB

    Guide me to design an Ideal Plan to Create this table (info. like PCTFREE, EXTENTS, etc.. and whatever information is required.)



    Regards

    Ramji

  2. #2
    Join Date
    Feb 2000
    Location
    Singapore
    Posts
    1,758
    I you are on 8i or above consider using LMT with UNIFORM extents.

    PCTFREE/PCTUSED depend on how the table data will be updated and deleted.. If you are going to have lot of updates that will increase rowsize, kepp PCTFREE high.
    And if the table data is going to bedeleted then at what % you wuld like the block to be returned to freelist for insertion again.

    HTH
    Sanjay

  3. #3
    Join Date
    Feb 2002
    Posts
    267
    create the the table based on some assumed vales

    Let it run for some time..then analyze the table and then recreate the table with alter table move command with new storage parameters

  4. #4
    Join Date
    Sep 2001
    Location
    Pondicherry-India
    Posts
    33

    Question Alloting Extents

    Hi Sonia,

    Can u guide me to allot the Initial Extent and Next Extent for Creating my Table. Is there is any Formula to Calculate these values ?


    Regards,

    Ramji

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448

    Re: Alloting Extents

    Originally posted by ramji_1123
    Hi Sonia,

    Can u guide me to allot the Initial Extent and Next Extent for Creating my Table. Is there is any Formula to Calculate these values ?


    Regards,

    Ramji
    no need to calculate this if you are using LMT, waste of time

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