cdr_deltab_000%

Posted in 2005

rotor — Tue, 15 Nov 2005 11:02:42 +0200 — source: Usenet: comp.databases.informix

Hi all! There are a lot of tables named like 'cdr_deltab_000%' in one database. Can anybody explain, what this tables is, when and how they are used, is it possible to drop them? -- Aeqok`rm{i onwrnb{i yhj opednqr`bkem http://pasts.delfi.lv sending to informix-list

↪ replying to rotor

scottishpoet — 15 Nov 2005 04:56:13 -0800 — source: Usenet: comp.databases.informix

did or do you have ER being used on that database?

↪ replying to rotor

Madison Pruet — Tue, 15 Nov 2005 09:53:41 -0600 — source: Usenet: comp.databases.informix

These are the deleted row tables used by ER conflict resolution. They are automatically created when a replicate is created which is using conflict resolution, and are dropped when the last replicate on that table using conflict resolution is dropped. We constantly prune the deleteed row tables, so generally they are fairly small. "rotor" <rotor@navigator.lv> wrote in message news:dlch7l$6mr$1@news.xmission.com... > > Hi all! > > There are a lot of tables named like 'cdr_deltab_000%' in one > database. Can anybody explain, what this tables is, when and how they > are used, is it possible to drop them? > > -- > Aeqok`rm{i onwrnb{i yhj opednqr`bkem http://pasts.delfi.lv > sending to informix-list