Longs and snapshots

From: Browett, Darren <dbrowett_at_city.coquitlam.bc.ca>
Date: Wed, 13 Dec 2000 08:12:11 -0800
Message-Id: <10709.124446@fatcity.com>

Hi,

I need to be able to snapshot a table that contains a long. I realize that you cannot do that.

I have tried one workaround, create a trigger/procedure on table A (the one with the long) that copies the data
to table B, then snapshot table B to the warehouse.

It almost works, but I get a morphing error. Can somebody direct me, or provide me
with examples and/or experiences with this situation. Maybe there is a different way to do it.

Thanks

Darren

---

---

Darren Browett P.Eng This message was transmitted
Systems Admin/DBA using 100% recycled electrons
Information and Communications Technology. City of Coquitlam
P:(604) 927 - 3614
E:dbrowett_at_city.coquitlam.bc.ca

---

---

Received on Wed Dec 13 2000 - 10:12:11 CST