Re: Table Fragmentation query

From: chilliinc6230@my-deja.com > >CREATE TABLE trans_table >(... >) FRAGMENT BY EXPRESSION>reconciled = "Y" AND extracted = "Y" in dbspace1 >REMAINDER IN dbspace2 > >Is it possible to change the fragment in dbspace1 to be a table rather >than a fragment ?? You mean detach the fragment into a separate table? >There, simple wasn't it ?? > >Basically, the idea is that because this table can't be deleted within >ER, we create a new table based on the fragment in dbspace1. Rather >than copying the data to another table (potentially 1 million+ rows) >which will obviously play havoc with the logical logs, can we just >transform the fragment into a table. I was wondering who stole my LSD, now I know...I'd love to read this post again in English... "this table can't be deleted within ER"? What does that mean? >I have thought it through logically, read the manuals, and come up with >the answer:- > >NO Apart from ALTER FRAGMENT DETACH? No. >Anyone have any other thoughts ?? I'd be fascinated to hear them ? >(relating to this topic of course, I don't want to hear about your >dogs' scabies...) My three-year-old daughter is an absolute genius! You want to see her play the piano. (You don't want to hear it, though!) And the traffic into work is just getting unreasonable. And wasn't it terrible about that train crash in London? And how about the rugby world cup? And what if Mozart was alive today? What would he think of Britney Spears? And where *is* my medication? ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com