948287 wrote:SURELY "designed" by an amateur that does not conform to Third Normal Form.
We are having a production database configured in oracle 10.2.0.4 ( standard edition) and its contains near to 50000 tables . The database is accumulated by more than 100 tables everyday,
jgarry wrote:Even at that (and I have the notes on that tacked to the wall of my cubical - we are an SE shop and I may need to use the technique) it's hard to imagine a rational design that's adding "more than 100 tables everyday"
I dunno, I could envision someone making a homegrown partitioning scheme in SE that is relational, sensible and cheap.
jgarry wrote:and "party lines"
Two daily tables with 50 states? Gets to 100 fast... just no info to know if it is stupid MS-think or what.
(In the early eighties, I worked for a department store concession that had files being uploaded nightly from hundreds of remote sites nationwide - with current tech, I could see external tables in such a use, though I would expect everything online these days anyways. I remember laughing at a story told in a computer class that Levi's outside salespeople would upload orders from payphones, but it didn't work with General Telephone equipment. [url http://www.retrojunk.com/content/commercial/23349/index/]Gee, no GTE was an ad at the time. Remember payphones?).