Re: creating index in diff. tabelsespace
From: osy45 <member18536_at_dbforums.com>
Date: Wed, 26 Feb 2003 19:22:57 +0000
Message-ID: <2578860.1046287377_at_dbforums.com>
Date: Wed, 26 Feb 2003 19:22:57 +0000
Message-ID: <2578860.1046287377_at_dbforums.com>
if you want to move existing indexes to another tablespace
generate sql like
select 'alter index ' || owner || '.' || index_name || ' rebuild tablespace <newidx_ts_name>;' from all_indexes where ...
-- Posted via http://dbforums.comReceived on Wed Feb 26 2003 - 20:22:57 CET