DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2001


    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.


  2. #2
    Join Date
    Nov 2000
    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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.