rebuild index to different tablespace

[gandolf989]

Originally posted by Mr.Hanky
Cmon quiz kid, the end of the movie, the old man by the bridge asks Arthur that question...Arthur responds and the old man (from scene 21) goes into the pit of fire.

Somehow it doesn't mean as much when taken out of context. You should try some more easily recognizable quotes.

Arthur Dent
"This must be Thursday. I never could get the hang of Thursdays."
The Hitchhiker's Guide to the Galaxy p25

"Ah, this is obviously some strange usage of the word 'safe' of which I wasn't previously aware."
The Hitchhiker's Guide to the Galaxy p50

"Ford, you're turning into a penguin. Stop it."
The Hitchhiker's Guide to the Galaxy p82

"It's at moments like this, when I'm trapped in a Vogon airlock with a man from Betelgeuse, and about to die from asphyxiation in deep space, that I wish I had listened to what my mother told me when I was young."
Ford Prefect: "Why, what did she say?"
Arthur: "I don't know, I didn't listen!"
The Hitchhiker's Guide to the Galaxy p75

http://en.wikiquote.org/wiki/Douglas_Adams#Arthur_Dent

[KenEwald]

Gooooosh! Yea, looks like Ken's got a case of the "Monday's"

How about rebuilding online? Big performance drain? (40gb 3 column pk index)

[Mr.Hanky]

Originally posted by KenEwald
Gooooosh! Yea, looks like Ken's got a case of the "Monday's"

How about rebuilding online? Big performance drain? (40gb 3 column pk index)

I love office space!

Online will require an estimated 40gig of additional space since it will literally rebuild the index before dropping the old one. So, your worst case scenario is another 40 gig index, although it should take up less space after a rebuild. I would do this off hours if I were you.

[KenEwald]

The INDEX_TYPE is "LOB", and if I'm reading the metalink articles right, it can't be rebuilt - online or off without:

Export, pre-create, import

This means a ton of downtime. What the heck! Guess rebuilding it should have been a design consideration.

If I had to do it over, I'd create it as an IOT and partitioned.

Doooh

[slimdave]

Originally posted by Mr.Hanky
Online will require an estimated 40gig of additional space since it will literally rebuild the index before dropping the old one.

I think that's true anyway, is it not?

[davey23uk]

Originally posted by Mr.Hanky
I love office space!

Online will require an estimated 40gig of additional space since it will literally rebuild the index before dropping the old one. So, your worst case scenario is another 40 gig index, although it should take up less space after a rebuild. I would do this off hours if I were you.

and the space to accomodate changes which are made during the rebuild