RE: sudden increase in size when doing CREATE TABLE ... SELECT ...

2002-10-14 Thread Hartmut Behrens
Hi there ! A sample create table SQL query is as follows : "create table eml.adjacency select * from emlbase.adjacency where eml.adjacency.importdate = '2002-10-10';" The database names (e.g. "eml") ,tablenames (e.g. "adjacency") and date are changed by a perl script for the different tables

re: sudden increase in size when doing CREATE TABLE ... SELECT ...

2002-10-14 Thread Victoria Reznichenko
Hartmut, Monday, October 14, 2002, 2:07:11 PM, you wrote: HB> Recently we have begun developing a web-based configuration sheet generator. The basis for these configuration sheets is data stored HB> on several Sun servers. The Sun servers are responsible for collecting HB> all config data from al

sudden increase in size when doing CREATE TABLE ... SELECT ...

2002-10-14 Thread Hartmut Behrens
Hi All ! Recently we have begun developing a web-based configuration sheet generator. The basis for these configuration sheets is data stored on several Sun servers. The Sun servers are responsible for collecting all config data from all equipment connected to the network. We have developed scr