FAQ

Database

Which service is right for me?

The Oracle Database Cloud Service is available in several different offerings. Database Schema Service (the schema-based APEX service) offering provides HTTPS access to the Oracle Database and is targeted at developers. Database as a Service and Virtual Image (the dedicated database instance service) are well suited for customers needing a full database or SQL*Net connectivity.
 
The following figure illustrates the architectural differences between these offerings:
 
Image denoting the difference between Multitenant and the Standard Edition or Virtual Image

top

top


Database Schema Service
Who is the schema offering right for?

Database Schema Service is ideal for developers looking to quickly create and deploy solutions in the Cloud.
 
This offering is well suited to Oracle Application Express developers who wish to develop or deploy Application Express applications in one schema or access data in their schema using RESTful Web Services.

top

top


How can I access the data in this service?

You can access data in your service in multiple ways, including:
  • From an Oracle Application Express application running in the Database Schema Service,
  • From a Java application running in an Oracle Java Cloud Service, or
  • Through RESTful Web Services.

top

top


How can I load data into this service?

You can load data into this service using SQL Developer, which allows users to quickly identify and transfer data from external data sources. You can also load data with various data import methods supported by Oracle Application Express, which supports importing data from text, XML, or CSV files.

top

top


Can I build and run reports on data in this service?

Yes. This service supports the Interactive Reports feature of Oracle Application Express, providing a powerful and flexible way to view and manipulate data.

top

top


Can I run existing applications outside this service and access the data through SQL*Net?

No. This service cannot be accessed using the SQL*Net network protocol at this time.

top

top


Can I move my applications and data from this service to another instance?

Yes. You can export your data and scripts (DDL) from this service and import them into any other Oracle Database 12c to reproduce your data structures, applications, and RESTful Web Services. In addition, Oracle Application Express application metadata can be exported and imported with simple SQL scripts.

top

top


What tools come with this service to manage my data and environment?

You can manage your data and data structures with SQL Developer or the tools in the Oracle Application Express SQL Workshop, which include an Object Browser, SQL command window, and a variety of other utilities. You can monitor the use of your service through the logging and monitoring capabilities of Oracle Application Express. You can also get information about storage usage on My Account and My Services.
 

top

top


How can I implement security on data in this service?

Oracle Application Express includes the ability to assign access privileges for all portions of your Oracle Application Express applications, from access to applications to access to pages, or even to individual items or report columns, based on user identity.
 
You can limit access to specific RESTful Web Services based on the specific client application making the request, the identity of the user, or the values within the data itself.
 

top

top


Database as a Service & Virtual Image
Who are these services right for?

Database as a Service and Virtual Image (the dedicated database instance services) are ideal for customers looking to run Oracle Databases in a Cloud environment.
 
Database Schema Service (the schema-based APEX service) provides only HTTPS access to the Oracle Database and is targeted at developers. This service offers full DBA and developer control and provides a full database accessible with SQL*Net.

top

top


Do these services support SQL*Net connections from outside the Oracle Cloud?

Yes. These services supports direct connections from outside the Cloud with SQL*Net.
 

top

top


How is storage allocated for these services?

Storage is a resource assigned to the underlying Compute Service. You can allocate storage up to 1 TB in 50 GB chunks.

top

top


How are users defined in these services?

Database users are defined in the Oracle Database(s) contained in the virtual machines you spin up. Each virtual machine included with this service has a privileged administrative user for that machine environment, as well as the standard SYS and SYSTEM users for the Oracle Database within the machine. Each service also has an administrative user for the overall environment.  You can define additional users with the environment management user console.

top

top


How can I define security for data in these services?

You use standard Oracle security grants to define security for data in these services.
 

top

top


Can I load additional software in these services?

Yes.  You can load additional software in these services; however, for Database Cloud, additional software may interfere with the automatic patch and upgrade processes.

top

top


What is the difference between the Database as a Service and Virtual Image?

Virtual Image provides a Compute environment with pre-installed virtual machine images that include all software needed to run an Oracle Database. You bring up the virtual machine and run the Oracle Database Configuration Assistant (DBCA) to create your database instance. All subsequent maintenance operations, including backup, patching and upgrades, are performed by you.
 
Database as a Service provides everything that the Virtual Image option offers, but also includes a pre-configured database through streamlined provisioning. You also get automatic backup, patching and upgrades, and point-in-time recovery for your Oracle Databases.

top

top


What Database editions are supported on these services?

Database as a Service and Virtual Image allow you to use Standard Edition One, Enterprise Edition, Enterprise Edition High Performance, or Enterprise Edition Extreme Performance within the limits of those licenses.

top

top


Is there any additional charge for support?

No. Support is included in the subscription price for these services.
 

top

top


What database options are included or available in these services?

Enterprise Edition includes no Database Options. Enterprise Edition High Performance includes all Database Options and Enterprise Manager Packs except RAC, RAC One Node, In Memory Database and Active Data Guard. Enterprise Edition Extreme Performance includes all Database Options with RAC, RAC One Node, In Memory Database and Active Data Guard. Some options are dependent on the Database version and also may only be available in future releases.

top

top


Are these services enabled to use Application Express?

Yes. All virtual machines for all service levels include Application Express and Application Express Listener. You can disable or remove Application Express from your virtual machines if you wish.
 

top

top


What cloud service is right for you?

Oracle offers a range of services for customers with different needs:

 
Service Ideal Customer
Compute Needs Cloud environment with complete control to install and setup any Oracle software. Also allows Bring Your Own License for any Oracle product.
Virtual Image Needs pre-installed Database software with complete control over environment.
Database as a Service Needs pre-configured databasewith complete control over environment and new cloud automation tools.
Database Schema Service Needs development and deployment platform for database and/or browser based applications.
 

top

top


Contact Us
Contact Us
Chat Now
Chat Now
Contact Us
×
Call us now
1-800-633-0738

Technical Support

Oracle Cloud Discussion Forums