Re: External Tables (support DML)

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 Received on Fri Apr 04 2008 - 04:55:25 CDT