Re: is it possible to use external tables in an oracle cloud database ?

Assuming one has a defined directory, a direct access to the OS (in the form of shell access is not needed) - one might operate on that through UTL_FILE. Of course this also means that all the operations like populating of that table would be processed through the UTL_FILE, so not necessarily reasonable, yet could be possible technically.

W dniu 25.11.2016 o 13:44, Jeff Smith pisze:
> There are several cloud solutions available from Oracle.
>
> The managed ones, Exadata Express and the Schema Service, do not offer access to the OS - so external tables are out.
>
> The DBaaS offering however, gives you your own machine you can do anything you want with, including access to the OS and things like creating and accessing External tables.
>
>
> ----- Original Message -----
> From: Kurt-Franke_at_web.de
> To: oracle-l_at_freelists.org
> Sent: Friday, November 25, 2016 7:41:14 AM GMT -05:00 US/Canada Eastern
> Subject: is it possible to use external tables in an oracle cloud database ?
>
> Hello list members,
>
> a short questions (may be the answer is not as short as the question):
>
> is it possbile to use external tables in an oracle cloud database ?
>
> if yes, are there limitations on it, i. e. limited access to directories accesible by the database at os level to store the data there ?
>
>
> regards
>
> kf
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
> .
>

-- 
Pole na kazi

----------------------------------------------------------------------
Remigiusz Sokolowski <remigiusz.sokolowski_at_nordea.com>
pos   : Senior DBA at DIiUSI
comp  : Nordea AB division in Poland
addr  : Luzycka 6A st, 81-537 Gdynia, Poland
phone : +48 58 667 17 43
mobile: +48 602 42 42 77
geo   : 54.4952N 18.4332E
--
http://www.freelists.org/webpage/oracle-l