Re: Database reorg
Bill Weaver wrote:
>
> I need to do some major reorg of my database including the moving of many tables from one
> dbspace to another. Is there an "easy" and possibly quicker way of doing this short of unload,
> drop, recreate, load method?
> --------------------------------------------------------
> Name: Bill Weaver
> E-mail: Bill Weaver <billw@fscorp.com>
> Date: 08/28/98
> Time: 13:21:38
>
> This message was sent by Z-Mail Pro - from NetManage
> NetManage - delivers Standards Based IntraNet Solutions
> --------------------------------------------------------
How about
ALTER FRAGMENT on table1 init in dbspace2
to move a table from dbspace1 to dbspace2
?
Neil Truby
Londis Holdings
London, UK