Re: is it possible to use external tables in an oracle cloud database ?
Date: Fri, 25 Nov 2016 05:05:34 -0800 (PST)
Message-ID: <dd291b37-0929-46f0-9012-aacc199f8053_at_default>
This is from the Exadata Express offering docs, same is true for Schema Service.
1 Feature Restrictions and Limitations
This section lists the feature restrictions and limitations associated with this release of Oracle Database Exadata Express Cloud Service. While these Oracle Database features are not currently available in Exadata Express, the intent is to enable many of them in a future release.
File System Access
Access to the host file system is disabled...
Again, the DBaaS offering does not restrict this feature, so you're good to go there. Define your requirements, then we can help you pick the better/best Cloud offering.
DBaaS has a Exadata tier available, so it's pretty flexible.
- Original Message ----- From: remigiusz.sokolowski_at_nordea.com To: oracle-l_at_freelists.org Sent: Friday, November 25, 2016 7:56:29 AM GMT -05:00 US/Canada Eastern Subject: 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 -- http://www.freelists.org/webpage/oracle-lReceived on Fri Nov 25 2016 - 14:05:34 CET