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.
Autonomous Database
Discussion List
-
The extended JSON data type REGULAR_EXPRESSION is not supportedSummary: I have an application that uses the MongoDB API for Autonomous JSON Database. I was attempting to do a case-insensitive find query on a collection using regex b… -
How to replace new line character in one of the value in CSV during DBMS_CLOUD.COPY_DATA call?Summary: This DBMS_CLOUD.COPY_DATA API is failing during importing data from Object storage to ATP that is having a new line characters in one if its value. We are tryin… -
Your Free Guide to Everything Autonomous at Cloudworld 2024To get you ready for CloudWorld 2024 in Las Vegas, I have put together a quick must-see guide covering all the important sessions, workshops, and tutorials by the Autono… -
How do I know when the unplanned maintenance (and possible interruptions ) will occur?Summary: I received the message last night that my Autonomous database needed to undergo maintenance however it did not give me a date or time. How do I know when this m…
-
Include the start_date and end_date OFS properties in the Oracle Autonomous DatabaseIs it possible to include the start_date and end_date OFS properties in the Oracle Autonomous Database configuration ? If not, how can I get this information?
-
Autonomous Database on OCI and Oracle EBS version 12.2.10Summary: Is the current version of the Autonomous Database on OCI offering compatible with Oracle EBS version 12.2.10, which operates on Oracle 19C? Content (please ensu…
-
ATP in Private subnet, how to access database action (sql developer web) and Apex over internetSummary: Hi Team, We have an ATP provisioned in private subnet, how can we access the APEX and Database Action over internet, any pointer to that would be helpful? Thank…
-
Database link between ADW and on-prem Oracle DatabaseSummary: Database link between ADW and on-prem Oracle Database How to configure dblink on ADW to on-prem Oracle Database? Networking is ok, path analyzer return view val…
-
IP address of public ADWSummary: Hi, We wish to connect to a compute instance (ODI MP) from ADW via Apex. For this ADW, network type is set to 'Allow secure access from anywhere', so there's no… -
ORDS cannot be reached using public IPSummary: We have several BIP reports where we have defined the data source for ORDS (see definition below) and they were working fine until around 19-Jul when the consol…
-
How to configure emailhi, I am using Always free database APEX on OCI version 24. I need to configure my OCI account and APEX to send emails. Is there an how-to ? Best regards. -
How to Migrate Autonomous Database with Workload type: APEXSummary: I am following This does not work for Autonomous Database with Workload type: APEX As Oracle Doesn't allow external connection Content (please ensure you mask a…
-
AI Assistant button not visibleHi, I have upgraded to APEX 24.1 on OCI. I cannot see the button AI Assistant in the SQL code editor. The bottom page of APEX shows relase 24.1 is installed :
-
How to rollback a tableHi, I am on always free offer on OCI. I have made a big mistake I have deleted records from a table. is it possible to rollback the table 24 hours ago ? Best regards. Ch…
-
how to send email from data transform service in ADBSummary: Data Transform Service in ADB allows to create dataflow, group dataflow to create workflow then schedule workflow to run specific schedule. But it does not have…
-
Unable to stop or restart free tier ATP databaseI am unable to restart an ATP database. The work request has the following error message: The Autonomous Database operation failed due to an unknown error. Refer to JobI…
-
Unable to log inHi, I am using Alwaye free OCI Database and APEX. I am developing software under APEX on the platform, every day. I received this mail that "Your inactive Always Free Or…
-
Update for Autonomous Database Severless for July, 2024We are continually adding new features and enhancements to Autonomous Database, and here are the latest updates along with information about the most recent sales wins: …
-
Security of a stored procedure enabled as a REST service in Oracle Autonomous DatabaseHello, I created a stored procedure on Oracle Autonomous Database and marked it as REST enabled. When I do not require authentication, the service works correctly, but w…
-
A Drive like One Drive ?Hi, I would like to know if there is a system to store data on the OCI for free accounts ? We would like to secure our data there. Best regards.
-
invalid credentials.I am using Always Free AD on the free OCI. I have installed Oracle. But when I try to connect to APEX on the cloud, I get an error message "invalid credentials." How to …
-
English language on Interactive reports options instead of frenchHi, I am using APEX 24.1 on OCI. The interactive Report button is "Actions" and the Actions are in english. And the systems messages "Row updated" for example, are in En…
-
Disable ACL on Autonomous DatabaseHi, I'm trying to disable ACL on my Autonomous Database, or more specifically, I'm trying to allow access to my APEX Workspace from everywhere, not just from the range o…
-
ORA-12530, TNS:listener: rate limit reachedSummary: How do I trouble shoot this error ? Content (please ensure you mask any confidential information): I observe this error in following configuration Automomous da… -
Getting ORA-43912 whilst trying to create a page as a copy on Apex using 23aiSummary: I've created a new 23ai Apex instance and imported three applications from an Apex instance running on 21c. When trying to copy a page between two of these appl…
-
Account has reached maximum limit for Always Free Autonomous Database instancesSummary: I terminated one of my two Free Autonomous DBs earlier today to make room for 23ai. I only see one DB in my list of Autonomous Databases. Despite that, when I a…
-
How to Call Oracle Data Integration (MarketPlace) Scenario from ADWSummary: Hi All, we have Oracle Data Integrator Market Place in Public Subnet and ADW provisioned in same Tenancy. Can someone please let us know the steps to Call ODI S…
-
Oracle HCM deep link to access to specific apex page integrated to HCMSummary: Hi Team, We have integrated the oracle apex application in fusion HCM. We have requirement to add the deep link in APEX email notification pointing to a specifi…
-
How to retrieve DB (nonpaid and non-production account) if autonomous db is forbidden.How to retrieve database (nonpaid and non-production account) if autonomous database is forbidden. Need urgent help. Thanks in advance.
-
My application login attempt return 503 error - Service UnavailableSummary: Unable to login into application, error 503 service unavailable Content (please ensure you mask any confidential information): When I look in dashboard, db is n…