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

Thread: Steps for Table Partition and Index partition

Hybrid View

  1. #1
    Join Date
    Jan 2001
    Posts
    642
    Sorry, I have 2 such tables, and the records in each are around 10 Million .

    Please help me.
    Badrinath

    Hi,

    I have a table which has reletively huge number of records (around 20Million). The table has the data for two companies ( "H" for HLP , "E" from entex)
    I have to do a lot of updates and deletes into these tables on the daily basis for both the companies.

    I have decided to go by the partitioning of the table on the company column.

    I have to decide the better way of doing the partitioning (Range or Hash) and the step, I need to do the partitioning.
    (If possible step by step). Also let me know if I can add another partition later on(In case of a third company).

    I would realy appreciate your advise and guidelines
    Badrinath

  2. #2
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    The answer to your question on partitioning is possible. For detailes on how to perform an index or table level partitions refer [url]http://technet.oracle.com[/url] or the oracle magazine site that had an article on how to partition tables a step by step.

    Since the concept is pretty wide, it is beyond the scope of explaining here.

    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


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