Results 1 to 2 of 2

Thread: Partitioning a table

  1. #1
    Contributing Member
    Join Date
    May 2006
    Answers
    75

    Partitioning a table

    What is meant by partitioning a table? Can someone brief me the ways for converting a non-partitioned table into partitioned one?


  2. #2
    Junior Member
    Join Date
    Oct 2006
    Answers
    24

    Re: Partitioning a table

    Decompose a table or index into smaller, more manageable pieces, called partitions. Each partition of a table or index must have the same logical attributes, such as column names, datatypes, and constraints, but each partition can have separate physical attributes such as pctfree, pctused, and tablespaces.

    e.g List partition:-

    CREATE TABLE sales_by_region (
    deptno NUMBER(10),
    deptname VARCHAR2(20),
    quarterly_sales NUMBER(10,2),
    state VARCHAR2(2))
    PARTITION BY LIST (state) (
    PARTITION q1_north VALUES ('UP', 'PU')
    TABLESPACE north,
    PARTITION q1_south VALUES ('AP', 'KE', 'MH')
    TABLESPACE south,
    PARTITION q1_east VALUES ('WB', 'BH', 'OR')
    TABLESPACE north);


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact