Hi Jared > I've seen some pretty ugly schemas in Oracle, from third > party apps in particular. > > It would be most interesting if an automated tool could > subset these.
They do get ugly don't they - however, I would be very suprised if DataBee was not able to cut a subset. DataBee is quite simple in concept - at its most fundamental level it processes a list of rules which tell it which tables need which supporting rows from other tables. The schema complexity is largely an irrelevant issue - DataBee takes things one rule at a time and says "I have this row in this table therefore I need these rows from this table based on this join condition). It is very fast and implicitly eliminates duplicates. It is also interesting to note that table size is also not super important. Sure the extract is slower on large databases, but the extract time scales upwards with the size in a very well behaved manner. Give it a try if you want. There is a fully functional evaluation version (with sample schema) available for download on the DataBee website. http://www.DataBee.com Thanks Dale Edgar Net 2000 Ltd. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dale Edgar INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
