To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Database
Discussion List
-
Read Write files from ATP DBSummary Is it possible to use UTL_FILE to read/write files from ATP DB?Content Hello Everyone, We have existing PL/SQL packages that read write files using UTL_FILE. We … -
DBaaS CLOB - Long StringSummary Need to store a long string to a DBaaS but can't pass as an argument to an INSERT instruction nor StoreProc as the string is longer than 4000xContent Hi all, I'v… -
PL/SQL Record/Table types in 18c databaseContent There is a difference in the way metadata is populated in "USER_ARGUMENTS" (SYS table) for RECORD and TABLE types between 12c and 18c databases. For same stored …
-
Supported way of running long scripts - vnc or screen?Summary Need for no-frills way of running long scripts on ExaCSContent I have a large database and the data is already copied into the cloud but I need to execute long o…
-
Difference between DBaaS(Database as a Service) and DBSaS(Database Schema as a Service)Summary Difference between DBaaS(Database as a Service) and DBSaS(Database Schema as a Service)Content Hi, Can anyone please let us know the difference between DBaaS(Dat… -
How to Enable Database Vault on DBCSSummary DV on DBCS - Configuring and Enabling Oracle Database VaultContent https://docs.oracle.com/en/cloud/paas/database-dbaas-cloud/csdbi/configure-and-enable-database… -
How to issue a curl command to test sending email using dbcs apx send_mail utilitySummary How to issue a curl command to test sending email using dbcs apx send_mail utilityContent Hi, I was advised to do necessary DBCS APEX email command setups in ord…
-
SQL Dev Web internal server errorSummary How do I recover from a SQL Dev Web 500 internal server errorContent I was running a query in SQL Dev Web. I got a message saying the request was cancelled and t… -
cannot add Database Backup Cloud ServiceSummary cannot add Database Backup Cloud ServiceContent Hi guys, I am new in using Oracle Cloud service and interested in using "Back Up Oracle Databases to Database Bac… -
DBCS access rules best practicesContent Dears, Kindly find below a document from Oracle, about how to connect Java application using JDBC to Oracle DB in the cloud. They are unblocking the port 1521, s…
-
Which TDE wallet is being used for TDE in BM OCI databasesSummary Which TDE wallet is being used for TDE in BM OCI databasesContent I have provisioned a database using Terraform in OCI with version Oracle Database 12c EE Extrem…
-
Connect DB Node through CLISummary Need to connect DB Node through CLI, we can easily provision DBCS on oracle cloud through cli , but in order to get access to Node we need its public Ip adderss,…
-
Web Service request limitSummary Error while trying to run rest/web service requests in PaaS DBContent We got an error while trying to run REST service in PaaS DB ORA-20001: You have exceeded th…
-
Create additional database using dbca on Cloud Database ServiceSummary Is supported to create a new instance using dbca in cloud database service?Content Hello, We have an Oracle Database Cloud Service (Not virtual image), we create…
-
Provising DBCS Using AnsibleSummary Provising DBCS Using AnsibleContent Hi , I Would like to get Modules for Provision of DBCS , Starting and Stoping of Instances using Ansible. Regards, Bharath
-
Getting error while accessing Oracle DBCS environment through SFTP with WinScpSummary Getting error while accessing Oracle DBCS environment through SFTP with WinScpContent Hi Team, I'm able to access Oracle DBCS environment through Putty using SSH… -
Oracle Cloud from SQL DeveloperSummary Connect Oracle Cloud database from SQL DeveloperContent Hi, I am failing to connect to Oracle Cloud Database from SQL Developer 1. SQL developer ver 18.3 2. Crea…
-
Add space to BM Instance post creationSummary Add space to BM Instance post creationContent I created a BM database Instance using Terraform When i initially created the BM.DenseIO2.52 instance , I specified…
-
Oracle Database Cloud Service. Beginning January 2019, Oracle Database 12c Release 2Summary Oracle Database Cloud Service. Beginning January 2019, Oracle Database 12c Release 2Content Please read below, it does not make sense....Oracle is saying we need…
-
Non CDB/PDB databases for Exadata Cloud at CustomerSummary Can we have 12C Non CDB databases hosted on An Exadata Cloud MachineContent We have 12c Databases which are non CDB on Premise supporting various applications. W… -
Create a local user in CDB$ROOTSummary How to Create a local user in CDB$ROOTContent Hi All, Can we create local user in CDB$ROOT ?? If Yes . Please Guide me. Version 12.2
-
Cancel query in SQL Dev WebSummary How do I cancel a query in SQL Dev Web?Content In the SQL Developer client I can cancel a query I've executed by clicking the red circle with an x. How do I do t…
-
How to set the Access Rules in the database cloud serviceContent I am not able to see anywhere that I can set "Access Rules" for my database cloud service. In the service menu I have: - open SQL Developer Web Console - open Ap… -
SQL Dev Web run timeSummary Where can I find SQL query times in SQL Dev WebContent In the SQL Developer PC client, the amount of time a SQL query took to run is displayed when the query fin…
-
Database Classic Quick Start UserSummary Is an ADMIN user created when you select Quick StartContent When you create a database using the Quick Start option, there are no connection details or user acco… -
APEX 5.1.3 installation in Oracle Cloud Infrastructure with os-user: opc?Summary APEX 5.1.3 installation in Oracle Cloud Infrastructure with os-user: opc?Content Dear all, I want to install APEX 5.1.3 in my Oracle Cloud Infrastructure. I depl…
-
Developer doubts in database costs after trial 30 daysSummary Developer doubts in database costs after trial 30 daysContent Hi all, As an Oracle database developer I would like to try oracle database in cloud, so I think th… -
Sign up for Usability Testing at OpenWorldSummary Sign up for Usability Testing at OpenWorldContent If you are attending Oracle OpenWorld this October, please consider participating in a usability test with us -… -
monitor DBaaS instance via command lineSummary monitor DBaaS instance via command lineContent Hello, Can we monitor DBaaS instances via command line i.e. I don't want to login to the GUI console to check whet…
-
Whitelisting IP-ranges for Oracle PaaS ServicesSummary Looking how to limit access to the Classic DBCS when accessing it from Oracle PaaS ServicesContent Hi, We have an Oracle Database Cloud Service Classic running i…