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 -> Moving Indexes to a different tablespace

Moving Indexes to a different tablespace

From: Bhaskar Ghosh <bhaskar_g1_at_verifone.com>
Date: 1997/03/04
Message-ID: <331C7FD6.5F85E4C8@verifone.com>#1/1

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 Tue Mar 04 1997 - 00:00:00 CST

Original text of this message

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