local index problem on new added partition
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: local index problem on new added partition

  1. #1
    Join Date
    Jan 2001
    Posts
    1

    Unhappy

    Help Experts,

    I have a local index built to cover the table made up of 3 partitions. The local index and data partition are on different tablespace and datafiles. For some reasons, I need to delete one of the exisiting partitions and create a new one. When I load data to the new partition, I discovered that the local index is built upon the datafile of the new added partition, but not the datafile which holds the exisiting local index.

    Q) How can the local index be adjusted, so that the index information of the new added partition will be built on the exisitng local index tablespace rather than the new data partition tablespace?


    thanks a million.

    amy

  2. #2
    Join Date
    Nov 2000
    Posts
    212
    try SQL
    'alter index modify default attributes' clause.
    O believe that default attributes can be tested by quering DBA_INDEXES.tablespace_name, etc

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