Re: External Tables (support DML)

From: Shakespeare <whatsin_at_xs4all.nl>
Date: Fri, 4 Apr 2008 13:25:37 +0200
Message-ID: <47f61032$0$14357$e4fe514c@news.xs4all.nl>

"SePp" <C_o_z_m_o_at_gmx.de> schreef in bericht news:ed80a0ab-e5cb-404d-92e1-b6fbebd3ff38_at_a1g2000hsb.googlegroups.com...

> On Apr 4, 10:12 am, "Shakespeare" <what..._at_xs4all.nl> wrote:

>> "SePp" <C_o_z_..._at_gmx.de> schreef in
>> berichtnews:de549433-a702-4544-9193-04602b00c315_at_m36g2000hse.googlegroups.com...
>>
>>
>>
>> > On Apr 3, 8:37 pm, joel garry <joel-ga..._at_home.com> wrote:
>> >> On Apr 3, 9:30 am, SePp <C_o_z_..._at_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

Well, the only way to perform DML I would know is to load the table in Oracle (or create a view, indeed); perform an update and rewrite the entire external table back to file (by an instead of trigger). Not something I would prefer indeed...

Shakespeare Received on Fri Apr 04 2008 - 06:25:37 CDT

Original text of this message