Re: Can you have the same table in two SE databases?

I think that I must re-iterate Art's comments. I started this discussion so I think it best if I put people out of their misery. I think Jonathan's answer is the best. Jonathan wrote:- ------------------------------------------------------------------------ You can do it in a number of different ways. Symbolic links, hard links, and CREATE TABLE ... IN "/path/name" all work - more or less. Beware of clobbering your data with the explicit create table option. First you have to create the table in each database - with all indexes in place - and only then go combining the two tables. Make sure you are very confident about how you set it up. If you're not sure, don't do it; it is very easy to mess things up. Review your backup and recovery strategies very carefully. Note that you may need different strategies for each database if you use symbolic links in one of them. I'm assuming your SE is recent enough not to use lock files - if it does, you have to create lock file and link that too (otherwise all hell breaks loose because the locking is not coordinated - a sure fire source of corruption!) Don't go altering the table, either. I'm not sure how supported it is - but it works because the o/s mediates the locking. Incidentally, if you need the index file and data file on different file systems, the only way to achieve that is with a symbolic link. -------------------------------------------------------------------------- My customer has been suitably warned. But today I found that for some of the files they want to map into the new databases there aren't .dat and.idx files so it can't be done for those. So I guess it won't be done. regards and thanks everybody Malcolm ----- Original Message ----- From: "Art S. Kagel" <kagel@bloomberg.net> To: <informix-list@iiug.org> Sent: Monday, November 03, 2003 5:51 PM Subject: RE: Can you have the same table in two SE databases? > On Wed, 29 Oct 2003 16:11:07 -0500, Francisco Roldan wrote: > > How did I get into this one? I have not done SE since 1990! I'm the last one > to ask. Personally I put my hard earned penny on Jonathan's words. To > summarize: > > - Doable > - It'll work > - It's flaky > - Recovery is dangerous, to say the least > - It's unsupported > - Don't do it. > > Art S. Kagel > > > > I place my bet on Art :-) > > sending to informix-list