When fragmenting by expression, can the following be done :
a)....
fragment by expression
dat1 < "01011990" in dbspace1,
remainder in dbspace2
I believe it can be done. When row is updated, is it moved
to appropriate dbspace ?
But
b)...
fragment by expression
dat1 < (today - 365) in dbspace1, -- (rows "older" then 1 year)
remainder in dbspace2
1) can be such expression used ?
2) will the "old" rows move to dbspace1 without explicit update ?
I suppose this will not work, but I'd like to be sure.
Thanks, Michal
--
--------------------------------------------------------------
Michal Hajek mailto:hajek@nspuh.cz
Sprava NIS http://www.nspuh.cz
NsP Uherske Hradiste phone : voice +420 0632 529 204
Purkynova 365 fax +420 0632 551 014
686 68 Uherske Hradiste Czech Republic
--------------------------------------------------------------