+42 to our friend Jeff Smith for pointing this (near term) limitation out
clearly. Without realizing that detail of contract and offering it would be
natural to think you could use directories. And as well to his advice that if
you're going to dip your toe into cloud service (or plan to take the plunge!) :
"Define your requirements, then we can help you pick the better/best Cloud
offering."
It seems to me that what I've heard about sales compensation for the near
future means they are aligned with customer needs the best they have been in
decades with it being good for them to get you the features you need and omit
any extra cost features you don't so they can attempt to turn your trials into
sales in an extraordinarily competitive environment: timesharing.
Er, I mean cloud. Really, it is called cloud now.
mwf
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On ;
Behalf Of Jeff Smith
Sent: Friday, November 25, 2016 8:06 AM
To: remigiusz.sokolowski@xxxxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: is it possible to use external tables in an oracle cloud database ?
This is from the Exadata Express offering docs, same is true for Schema Service.
http://docs.oracle.com/cloud/latest/exadataexpress-cloud/CSDBK/GUID-0FD6DE2D-93AC-4A5F-A8FB-B4C86DF0B4F8.htm#CSDBK-GUID-0FD6DE2D-93AC-4A5F-A8FB-B4C86DF0B4F8
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@xxxxxxxxxx
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxx
To: oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
.