Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

LOB INDEX PROBLEM

Status
Not open for further replies.
heihojin

heihojin

Technical User
Sep 11, 2002
9
US
I have a lob (fname) with an index on it. How do I move the index from tablespace_B and to tablespace_A. My understanding is that you cannot alter or drop lob indexes.
 
Status
Not open for further replies.

Similar threads

slicendice
  • Locked
  • Question
Best type of index to use...?
Replies
3
Views
172
taupirho
taupirho
Toe
  • Locked
  • Question
putting lob column into raw
Replies
1
Views
89
LKBrwnDBA
LKBrwnDBA
dabiri
  • Locked
  • Question
Problem connecting to oracle 10g database.
Replies
18
Views
437
dabiri
dabiri
pramsam1
  • Locked
  • Question
With Clause with UNIONS - how to enforce indexes
Replies
1
Views
281
LKBrwnDBA
LKBrwnDBA
cmmrfrds
  • Locked
  • Question
Use index to avoid full table scan
Replies
2
Views
135
sem
sem

Part and Inventory Search

Sponsor

Back
Top