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
-
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… -
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… -
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: … -
My Oracle Free Tier-database-instance has disappeared.Summary: Last connections might be 2 weeks ago, but certainly not 90 days. Why did it disappear and, more important, how can I recover the instance? Content (please ensu…
-
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… -
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 …
-
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 :
-
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…
-
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…
-
How to Migrate Autonomous Database with Workload type: APEXSummary: I am following https://blogs.oracle.com/datawarehousing/post/migrate-21c-to-23ai This does not work for Autonomous Database with Workload type: APEX As Oracle D…
-
A quick and easy way to migrate your Always Free 21c instances to 23aiSummary: With the introduction and availability of Oracle’s latest database version, Oracle Database 23ai, in our Always Free tier, you can now migrate your Always Free …
-
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.
-
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 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…
-
APEX REST BASED LOV Don't show all valuesSummary: APEX REST BASED LOV Don't show all values Content (please ensure you mask any confidential information): Hi, I have created a Rest Data Source Based LOV and it …
-
How to connect ADB via command line in Mac OSSummary: How to connect ADB via commandline in Mac OS Content (please ensure you mask any confidential information): I am trying to connect to ADB from Mac OS Command li…
-
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…
-
My free database is always stopped since the trial period has expiredSummary: My free database is always Stopped since the trial period has expired. Content (please ensure you mask any confidential information): I doesn't use more than 20…
-
Converting ATP from OCPU to new ECPU metric defaults to higher ECPU numberSummary: Converting ATP from OCPU to new ECPU metric defaults to higher ECPU number Content (please ensure you mask any confidential information): ATP database from 2 OC…
-
APEX Report with SQL using WITH clause function gives error.Summary: Below query works fine in APEX SQL Workshop, but gives error (ORA-32034: unsupported use of WITH clause) when creating an APEX Interactive report. with FUNCTION…
-
My Always free ADBs just disappeared. What happened?Hi Without receiving any previous notification, my 2 always free ADBs just disappeared, they don't show in my ADBs list in any of my 3 compartments, they're gone. They w…
-
Bucket Name list is empty in Data Pump Import dialog boxHello, I has tried to import direct pump (dmp) file to my autonomous database. I already have this dmp file in my bucket (object storage). So problem is, when I try to s…
-
Troubleshooting DBMS_CLOUD access to object storageSummary: I tried to access the object storage from ADB (free tier) but failed with "ORA-20401: Authorization failed for URI". Is access to object storage supported in fr…
-
ORA-65114 / Usage in container is too high / Problem: Cannot shrink Data Tablespace !Hi, The current situation on my Always Free tenant/Autonomous Transaction Processing DB: jofodb/jofodb1: SQL> select round(sum(bytes/1024/1024/1024),2) Size_gb from dba_… -
Golden Gate reconfiguration after source database RMAN cloneSummary: Customer is using Golden Gate (Cloud) to transfer data from on-prem Peoplesoft database to Oracle ADW. In DEV/UAT environments, the source Peoplesoft database w… -
Why occurs this error "ORA-01841: (full) year must be between -4713 and 9999, and not be 0"?Summary: When I try to do a SQL with a parameter date occurs this error "ORA-01841: (full) year must be between -4713 and 9999, and not be 0" SQL: select * from GL_DAILY… -
How to re-create tenancy in always-free subscriptionSummary: Hi, I have an always-free account on cloud.oracle.com. I wanted to have this account terminated and request a new one in Chicago region, but I was able to termi…
-
ATP Private Endpoint - 502 Bad GatewayHi, Looking for advice on how to troubleshoot further our ADB, which we aren't able to access via our private endpoint URL anymore. Our setup follows this guide, with pr…