Path: text.usenetserver.com!out01b.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!news1.google.com!border1.nntp.dca.giganews.com!nntp.giganews.com!nx01.iad01.newshosting.com!newshosting.com!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!feeder.news-service.com!newsfeed.xs4all.nl!newsfeed2.news.xs4all.nl!transit.news.xs4all.nl!xs4all!transit3.news.xs4all.nl!post.news.xs4all.nl!not-for-mail From: "Shakespeare" Newsgroups: comp.databases.oracle.server References: <779a3b96-8da0-4d40-a6cb-82ccb5d451a6@a22g2000hsc.googlegroups.com> <55af4c83-f2ab-4165-8053-c1c07caac76e@e10g2000prf.googlegroups.com> Subject: Re: External Tables (support DML) Date: Fri, 4 Apr 2008 10:12:37 +0200 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.3138 X-RFC2646: Format=Flowed; Original X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198 Lines: 35 Message-ID: <47f5e2f7$0$14355$e4fe514c@news.xs4all.nl> NNTP-Posting-Host: 82.95.215.210 X-Trace: 1207296759 news.xs4all.nl 14355 [::ffff:82.95.215.210]:49972 X-Complaints-To: abuse@xs4all.nl Xref: usenetserver.com comp.databases.oracle.server:443411 X-Received-Date: Fri, 04 Apr 2008 03:12:40 EST (text.usenetserver.com) "SePp" schreef in bericht news:de549433-a702-4544-9193-04602b00c315@m36g2000hse.googlegroups.com... > On Apr 3, 8:37 pm, joel garry wrote: >> On Apr 3, 9:30 am, SePp wrote: >> >> > Hi all, >> >> > I have a question about Oracle and External tables. >> >> > Does Oracle official support external tables? I read some articles >> > that it is possible with some workarounds, but is it also supported by >> > Oracle? >> >> > Is it recommended to do DML on external table? >> >> Go to tahiti.oracle.com and put in the term: >> external tables >> >> Look at the Overview of External Tables. >> >> jg >> -- >> @home.com is bogus.http://www.exboyfriendjewelry.com/ > > Neither data manipulation language (DML) operations nor index creation > are allowed on an external table. > > Thx But you CAN load data from Oracle into an external table (while creating it) Shakespeare