Re: Question about Moving Table Between Tablespace

From: F Lange <flange_at_pt.lu>
Date: 1997/09/24
Message-ID: <01bcc91f$ff92a120$8cd79ac2@fql10>#1/1

Hi,
The trigger will be lost !
Export the table with rows=Y if you need to keep the data ROWS=N otherwhile.
Drop table.
import indexfile=/tmp/index.sql
edit the file and change the tablespace name, create the table.

Import everything with ignore=Y.

The trigger will not be fired because it's created after the data load.

-- 
Regards F. Lange Certified DBA.
29A route du vin.
L5450 Stadtbredimus.
Grand Duchy of Luxembourg.
flqnge_at_pt.lu
(int) 352 697412
(cel) 352 021193652
Phone numbers are variable length.
Luxembourg is a small country of 80 miles on 60 miles between France,
Germany and Belgium.


Morris Wong <morriswg_at_netvigator.com> wrote in article
<3429036B.305_at_netvigator.com>...


> 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 Wed Sep 24 1997 - 00:00:00 CDT