Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Question about Moving Table Between Tablespace

Re: Question about Moving Table Between Tablespace

From: Ken Nichols <knichols_at_mcsilo.ilo.dec.com>
Date: 1997/09/25
Message-ID: <342A6794.4788@mcsilo.ilo.dec.com>#1/1

Morris,

The trigger is dropped automatically when you drop the table.

Ken

Morris Wong 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
  Received on Thu Sep 25 1997 - 00:00:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US