From oracle-l-bounce@freelists.org Fri Jan 28 02:12:57 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j0S8CvKK001202 for ; Fri, 28 Jan 2005 02:12:57 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j0S8Ckem001189 for ; Fri, 28 Jan 2005 02:12:46 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4E14066CFC; Fri, 28 Jan 2005 02:04:54 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 28861-08; Fri, 28 Jan 2005 02:04:54 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C4E3366989; Fri, 28 Jan 2005 02:04:53 -0500 (EST) X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message Subject: RE: Goofy Late Night Idea? MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii Content-Transfer-Encoding: 8bit Date: Fri, 28 Jan 2005 01:03:00 -0600 Message-ID: <83FCA77436D6A14883E132C63F4101D0024A3296@pscdalpexch50.perotsystems.net> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: Goofy Late Night Idea? Thread-Index: AcUE/ioYV7sQ6qa8QZqHr0BjcPlrNwABnyPw From: "Post, Ethan" To: , Cc: X-archive-position: 15384 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Ethan.Post@ps.net Precedence: normal Reply-To: Ethan.Post@ps.net X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at example.com X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on air891.startdedicated.com X-Spam-Status: No, hits=0.0 required=5.0 tests=none autolearn=ham version=2.60 X-Spam-Level: Let me get back to the idea that what I am striving for is simplicity. External tables are a great example of taking a need "interacting with data in files outside the database" and making it really simple. I would love to see something like this... create ftp 'myftp' port 9000 default '/tmp/inbound'; grant all on myftp to scott; create table foo (x blob); alter table foo use myftp; presto! all of a sudden you get a couple java procs that are acting as ftp servers for the database and handling all requests coming into port 9000. Scott can ftp files into the database without requiring a OS login. Of course I will want some DD tables/views such as V$FTP_STATS etc...of course if Larry's vision of the database becoming the OS comes true then perhaps things really will be this simple. I do see the beauty of that idea. My bet is the demos are as simple as that but I might be wrong! -----Original Message----- From: oracle-l-bounce@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Christian Antognini Sent: Thursday, January 27, 2005 11:58 PM To: RMohan@arbinet.com Cc: oracle-l@freelists.org Subject: RE: Goofy Late Night Idea? Hi Ross >The only demos I see there are just kind of vanilla "use JDBC" for = =3D3D >loading stuff. I kept thinking Ethan was going for direct dbms data = =3D3D >injection via library through EXTPROC (in "wrong" direction, of =3D course), =3D3D >without requiring=3D3D20 >JDBC. > >To do this, I guess you could dump a client-based *.doc via ftp into a =3D =3D3D >dbms-server based and have a db-internal process polling = =3D for =3D3D >results in and formatting same appropriately (via EXTPROC = =3D =3D3D >and library def) for storage. You get ability to asynchronously upload =3D =3D3D >stuff and format it into db mediated by EXTPROC > >This would obviate the use of JDBC to inject data in the db.=3D3D20 I didn't give a look to the link... anyway I know for sure that it's =3D possible to use a standard FTP client to load data in the DB (in fact I =3D do such a demo every time I teach either a 9i New Feature course or a = =3D XDB course...). >(Of course, it IS very late) It depends where you are ;-) I'm sitting at 6:57AM... Cheers Chris -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l