From: hrishys@yahoo.co.uk (hrishy) Newsgroups: comp.databases.oracle Subject: Re: data handling issue Date: 2 Mar 2004 20:12:41 -0800 Organization: http://groups.google.com Lines: 72 Message-ID: <4ef2a838.0403022012.1f83b19b@posting.google.com> References: <%Y3%b.56084$Xp.266401@attbi_s54> NNTP-Posting-Host: 203.200.211.65 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: posting.google.com 1078287161 11350 127.0.0.1 (3 Mar 2004 04:12:41 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Wed, 3 Mar 2004 04:12:41 +0000 (UTC) Hi Engineer from india here :-)..Well there are many different ways to ask a question and depending on the way its asked you would get many different responses :-). Your problem can it be understood this way you want to better manage archival data that keeps on growing but is huge and you need it online. Well one possible solution would be to dig into the oracle Docs and look into partitioning.Which is divide and conquer approcah for managing data .Specifically look at range partitioning. well if you want to be sure that usenet advice really works for you you should take a hint and start doing test for yourself.You are smart hmm and you will take every advice offered here and test it out. And if you are too lazy well indian engineer here would welcome you with open arms ..remember outsourcing is just a arms length away. :-)) regards Hrishy P.S:Please keep outsourcing and other bull shit away from this news group folks. I hate it this forum is meant for oracle and technical discussions. josephcurwen@despammed.com (curwen) wrote in message news:... > Jim, > I do have some experience, maybe this is the most complex project I > have dealt with, but we have enough time and resources to improve the > skills if required.. > anyway the project is not so mission critical, even if a lot of data > are expected, and from a general point of view the factors are quite > calibrated > > anyway we used range partitioning to handle the issue > > best regards > jc > > > "Jim Kennedy" wrote in message news:... > > "curwen" wrote in message > > news:cc68edc4.0402270027.4c59b7c9@posting.google.com... > > > > > jc > > > > I always find it strange that we see requests like this. Sort of along the > > > > lines of "I am building this huge Oracle database and I don't know much > > > > about Oracle but..." Wouldn't one get people on the project who have some > > > > knowledge and expertise on Oracle? It just strikes me as very odd. > > > > Jim > > > > > > > > > My experience in computer science is limited, I only have a First > > > Class Masters degree in Electronics Engineering, but I'm confident > > > with hard working and studying I can become 'good' as you > > > > > > plus, I'll be much more professional answering in Usenet > > > > > > thanks anyway > > > jc > > I am sure you are a hard working good person. My comment has nothing to do > > with your personality, but rather why people do this. (more the fault of > > the manager from not getting experienced people for a task that needs an > > experienced person) It is sort of like I've been hired to design a Boeing > > 747 and I have experience building paper airplanes. There is quite a gulf > > there in needed experience. > > Jim