Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Location
    Karachi, Pakistan
    Posts
    45

    Smile Unanswered: Re-locating PK (system generated) Indexes

    I want to re-locate Primary Key (System generated) indexes into the tablespace of my choice.

    when i create a primary key on such column, By-default indexe is generated in the same tablespace where the table is located. but i want to create that indexe in a different tablespace due to performance hit.

    Please Reply me as soon as possible, becuase i am on the phase of implementation of my schema on actual Server.

    Noor

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    System generated primary keys? So I guess you didn't use simple CREATE TABLE command, but did it through Designer or something like that?

    Primary keys are created, within CREATE TABLE as
    PHP Code:
    CREATE TABLE table_1
    field_1   NUMBER(2)   CONSTRAINT pk_tab1_f1 PRIMARY KEY
                            USING INDEX TABLESPACE idx_tblspc
    ,
      
    field_2 ...
    ); 
    Doesn't Designer allow you to define default index tablespace?

    However, you could realocate your indexes using

    ALTER INDEX <index_name> REBUILD TABLESPACE <index_tablespace>;

Posting Permissions

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