moving tables from one tablespace to another

From: Jessie Shu <yshu_at_vt.edu>
Date: Tue, 17 Aug 1999 10:22:51 -0400
Message-ID: <37B9703B.42DCA31A@vt.edu>

Hi! All,
Does anyone have any good suggestion about moving tables from one tablespace to another? These tables have data inside. And currently we are going to

1) export those tables
2) drop them from DB
3) recreate them in new tablespace
4) import them with IGNORE=Y

But I was wondering if there is a better way of doing this. Thanks! Received on Tue Aug 17 1999 - 09:22:51 CDT