Path: text.usenetserver.com!out04a.usenetserver.com!news.usenetserver.com!in02.usenetserver.com!news.usenetserver.com!postnews.google.com!a1g2000hsb.googlegroups.com!not-for-mail
From: SePp <C_o_z_m_o@gmx.de>
Newsgroups: comp.databases.oracle.server
Subject: Re: External Tables (support DML)
Date: Fri, 4 Apr 2008 02:55:25 -0700 (PDT)
Organization: http://groups.google.com
Lines: 46
Message-ID: <ed80a0ab-e5cb-404d-92e1-b6fbebd3ff38@a1g2000hsb.googlegroups.com>
References: <779a3b96-8da0-4d40-a6cb-82ccb5d451a6@a22g2000hsc.googlegroups.com> 
 <55af4c83-f2ab-4165-8053-c1c07caac76e@e10g2000prf.googlegroups.com> 
 <de549433-a702-4544-9193-04602b00c315@m36g2000hse.googlegroups.com> 
 <47f5e2f7$0$14355$e4fe514c@news.xs4all.nl>
NNTP-Posting-Host: 192.250.175.26
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Trace: posting.google.com 1207302925 22065 127.0.0.1 (4 Apr 2008 09:55:25 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Fri, 4 Apr 2008 09:55:25 +0000 (UTC)
Complaints-To: groups-abuse@google.com
Injection-Info: a1g2000hsb.googlegroups.com; posting-host=192.250.175.26; 
 posting-account=Jag27AoAAAAY0dYkd9hqvb2HExrXm4cS
User-Agent: G2/1.0
X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.8.1.13) 
 Gecko/20080311 Firefox/2.0.0.13,gzip(gfe),gzip(gfe)
Xref: usenetserver.com comp.databases.oracle.server:443416
X-Received-Date: Fri, 04 Apr 2008 04:55:26 EST (text.usenetserver.com)

On Apr 4, 10:12 am, "Shakespeare" <what...@xs4all.nl> wrote:
> "SePp" <C_o_z_...@gmx.de> schreef in berichtnews:de549433-a702-4544-9193-04602b00c315@m36g2000hse.googlegroups.com...
>
>
>
> > On Apr 3, 8:37 pm, joel garry <joel-ga...@home.com> wrote:
> >> On Apr 3, 9:30 am, SePp <C_o_z_...@gmx.de> 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

I read about that. It's possible since 10g. But thats not Data
Manipulation on the external files.

Somewhere I found an article that you can do DML on external files by
the use of instead of triggers and views. ....

Anyway, Oracle doesn't supports it officially.

Thanks
Sebastian