Database Schema as a Service - Oracle Cloud

Cloud computing is known for many things: cost effectiveness, flexibility, scalability.

Oracle Cloud provides several Oracle Database offerings. Choose between a single schema based service, or a virtual machine with a fully configured running Oracle Database Instance, or Exadata Service with all the database features, options, and workloads.
Oracle Cloud Provide Database schema Service as: 
  • 1 Schema on Oracle Database 11g
I don't know, can we request on Oracle Database 12c Release 1. But I think in the future can provide on 12c version  
  • Choice of 5, 20, and 50 GB database storage (1GB for trial account) 
I subscribed to Oracle Database Cloud Service. 


After completed my order, my Oracle Database Cloud Service - S20 activated



  • Includes Oracle Application Express (APEX), version 4.2.6, a highly productive browser based application development framework for creating responsive applications with SQL and PL/SQL 
  • Data access using RESTful Web Services 

I'm using Oracle APEX  since 2003 year (HTMLDB2 - first name of  APEX), it is my favorite rapid Database Development tool included into Oracle Database. You can use RESTFul Web Services after 4.2 version of Oracle APEX. 





1. You must connect cloud service, using "My Service URL"



2. Open service Console 




  • No SQL*Net access 
You cannot connect  Database Cloud Service via SQL*Plus or other tools, which is using SQL*Net. But You can  connect Cloud Database Schema with SQL Developer. 

1. Create new connection on Cloud Connection 



2. You can create any  types objects in this schema now. 


You can load your data with  SQL  Developer to Cloud Database. Please check following tutorial.
Data Loading and the Oracle Database Cloud Service

Note: you can use SQL Workshop in  Oracle APEX, but I think SQL Developer very easy for developers. Oracle Database Cloud Service fully managed by Oracle - no DBA necessary. 

Mahir M. Quluzade

Comments

  1. Replies
    1. IEEE Cloud computing DOamin is a general term for anything that involves delivering hosted services over the Internet. IEEE Projects on Cloud Computing The cloud is a metaphor for a global network of remote servers which operates as a single ecosystem, commonly associated with the Internet. IEEE FInal Year Project Domains Final Year Projects for CSE cloud computing is the delivery of computing services—including servers, storage, databases, networking, software, analytics, and intelligence


      JavaScript Training in Chennai


      JavaScript Training in Chennai

      Delete
  2. The blog shares a lot of worthy things. Keep going..

    Technology
    kolindia

    ReplyDelete
  3. We are a part of the success story for many of our customer's successful cloud Migrations.
    Cloud Migration services

    Aws Cloud Migration services

    Azure Cloud Migration services

    ReplyDelete
  4. Thank you for the informative post about Security challenges in AWS , Found it useful . cloud migration services have now become secured and with no-risk
    Vmware Cloud Migration services

    Database Migration services

    ReplyDelete
  5. I am really impressed with the way of writing of this blog. The author has shared the info in a crisp and short way.
    Lia Infraservices

    ReplyDelete
  6. We are a part of the success story for many of our customer's successful cloud Migrations.
    Cloud Migration services


    Best Cloud Migration Tool

    ReplyDelete
  7. I read your post and got it quite informative. Your article is very useful for us because it very nicely describes the importance of oracle database in the programming language. oracle database coaching classes in jaipur

    ReplyDelete
  8. Oh , great! Downloaded a trial version. Looks nice, thanks!

    ReplyDelete
  9. A IEEE project is an interrelated arrangement of exercises, having a positive beginning and end point and bringing about an interesting result in Engineering Colleges for a particular asset assignment working under a triple limitation - time, cost and execution. Final Year Project Domains for CSE In Engineering Colleges, final year IEEE Project Management requires the utilization of abilities and information to arrange, plan, plan, direct, control, screen, and assess a final year project for cse. The utilization of Project Management to accomplish authoritative objectives has expanded quickly and many engineering colleges have reacted with final year IEEE projects Project Centers in Chennai for CSE to help students in learning these remarkable abilities.



    Spring Framework has already made serious inroads as an integrated technology stack for building user-facing applications. Spring Framework Corporate TRaining the authors explore the idea of using Java in Big Data platforms.
    Specifically, Spring Framework provides various tasks are geared around preparing data for further analysis and visualization. Spring Training in Chennai

    ReplyDelete

Post a Comment

Popular posts from this blog

Which device is mapped Oracle ASM disk?

Oracle Data Guard 11g - How to safely remove a Data Guard Broker configuration?

Oracle Database 12c Release 2 - Long Identifiers