Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Changing Tablespace of Primary + Foreign key indexes

Re: Changing Tablespace of Primary + Foreign key indexes

From: Terry Ball <terry_ball_at_csgsystems.com>
Date: Fri, 21 May 1999 08:30:34 -0500
Message-ID: <37455FFA.1EBEF529@csgsystems.com> 





At least in 7.3 and later, you can just issue an alter index ...
rebuild.



I have done this many times to change the tablespace of a PK.



Terry Ball


Sr. DBA, CSG Systems



Matt Randle wrote:



> Thanks for the replies.


>


> Matt.



Received on Fri May 21 1999 - 08:30:34 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US