Re: Question about Moving Table Between Tablespace

From: Erik Oosterling <Oosterling_at_compuserve.com>
Date: 1997/09/25
Message-ID: <342b1ec9.3580721@news.xs4all.nl>#1/1

On Wed, 24 Sep 1997 20:11:23 +0800, Morris Wong <morriswg_at_netvigator.com> wrote:

>Hi all,
>
> I have to move a table from one tablespace to another.
> The table has index and trigger. If I simply drop and then
> create the table and index, will the trigger be affected?
>
> Thank you.
>
>BR,
>Morris
>morriswg_at_netvigator.com

You have to recreate the triggers as well. When you delete a table all objects related to the table will be deleted. Constraints, grants, triggers and comments.

Goodluck Received on Thu Sep 25 1997 - 00:00:00 CDT