fragment question
Posted in 1998
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 --------------------------------------------------------------