Re: Moving Indexes to a different tablespace

From: L120bj <l120bj_at_aol.com>
Date: 1997/03/06
Message-ID: <19970306002800.TAA16945@ladder01.news.aol.com>#1/1

If you are using Oracle 7.3 check out the alter index ... rebuild command, this allows you to rebuild an index in a different tablespace etc. Primary keys can be rebuilt in this way, I've done it. If you need any info. mail me.

---

---

Subject: Moving Indexes to a different tablespace From: Bhaskar Ghosh <bhaskar_g1_at_verifone.com> Date: Tue, 04 Mar 1997 12:02:30 -0800
Message-ID: <331C7FD6.5F85E4C8_at_verifone.com>

I want to move indexes of my schema from one tablespace to another, I did an export of the User and then imported the exported file into an Indexfile. What I see is all the Table creation scripts are commented out. But there are no scripts to create indexes. Can anyone help me with some suggestion. Except one index all my other indexes are created as a result of a Primary Key or Unique Constraint.

-- 
	Bhaskar Ghosh	
	Technical Support Engineer
	Verifone Inc, SFO
	e-mail	: bhaskar_g1_at_verifone.com				 
	Phone #	: 415 598 5661 (Daytime)

Received on Thu Mar 06 1997 - 00:00:00 CST