Path: news.netfront.net!news.glorb.com!postnews.google.com!d21g2000prg.googlegroups.com!not-for-mail From: Totti Newsgroups: comp.databases.oracle.misc Subject: Re: formula help please Date: Sat, 5 Jan 2008 15:58:42 -0800 (PST) Organization: http://groups.google.com Lines: 11 Message-ID: References: <4f59e4fd-9139-486e-8068-2596a54be95f@e6g2000prf.googlegroups.com> NNTP-Posting-Host: 77.49.39.49 Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Trace: posting.google.com 1199577522 12340 127.0.0.1 (5 Jan 2008 23:58:42 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Sat, 5 Jan 2008 23:58:42 +0000 (UTC) Complaints-To: groups-abuse@google.com Injection-Info: d21g2000prg.googlegroups.com; posting-host=77.49.39.49; posting-account=rV2knwkAAADEi-vbP64IHTREfm2MhMvq User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322),gzip(gfe),gzip(gfe) Xref: news.netfront.net comp.databases.oracle.misc:66761 Charles, the tables are huge > 2000 rows each. so as u pointed that must be a problem; the other problem is that as i am checking the .txt file , the data is generated from, i can see no costraints in the creating tables statments, and as i understood from you, the constraints and the primary and foreign keys are essentials in solving such problems. what do you suggest now? should i drop present tables and put constraints in re-generating the data? or could i work it out in another more sophisticated way? Thank you very much Charles you are being very helpful for me.