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
-
Loading database via live feed not loading alphanumeric data on Autonomous DBSummary: When loading data via Autonomous DB the data load does not load entries that are alphanumeric even though data type is set to VarChar2 Content (please ensure yo…
-
All Always Free 21c instances have been decommissionedPlease note that all Always Free 21c instances have now been decommissioned and are no longer available. Some instances may still be visible on your OCI console but you …
-
PLS-00904: insufficient privileges to access object PUBLIC.DBMS_CLOUDHello, I have compiled a DB package with the admin user and I get a privilege error. I have modified the package and it gives me error, and it was working fine before. T…
-
Oracle Cloud is getting a new fresh look & feel - Redwood styleWhen you sign in to Oracle Cloud, the OCI home page might have a completely new look. Our cloud team is rolling out the new Redwood-style look-and-feel across all the se…
-
Blog Post - Overview of observability and management cloud services for Autonomous DatabaseJust published a set of blog posts on the various Autonomous Database Serverless. Although Autonomous Database is a highly automated service, it does provide cloud and f…
-
Linking Oracle Object Storage File as External Table in ADWHi, I work on the EPM side of things normally, but recently signed up for a free OCI account to test out ADW functionality (since this functionality is coming as a free …
-
GA Announcement: Set CPU/IO Shares for Autonomous Data WarehouseSummary Autonomous Database now allows customers to change the CPU/IO shares for the consumer groups within their ADB instance (high, medium, low, tp, tpurgent).Content …
-
It is possible recover / restore from last backup AlwaysFree 21c databaseSummary: Hello everyone, I know, OCI has informed that the AlwaysFree 21c databases will be removed. But TBH, I have found in my mailbox just one e-mail about it. But ok…
-
Announcing new advanced monitoring for Autonomous Databases with OCI Database ManagementWe are excited to announce that OCI Database Management service now has new, easy-to-use tools that enable advanced monitoring and management of ADB resources. These too…
-
Inporting application from an Autonmous database to another on OCIHi, I am on alway free database unsing APEX database. I wouldlike to import application from one database to another. What are the steps involved ? Best regards.
-
how to connect to oracle Cloud 24c FSCM database from ExcelSummary: I would like to know the steps to connect to oracle Cloud 24c FSCM database from Excel. Content (please ensure you mask any confidential information): Version (…
-
The Autonomous Database operation failed due to an unknown error.Summary: Good morning, My OCI Autonomous Database is currently in a STOPPED state and will now not restart. When trying to restart, it takes around 20 minutes and then g…
-
Unable to copy JSON data from OCI Object storage to DB tableSummary: I have a JSON payload in OCI Object Storage and is available through public URL.I am trying to copy this data to an existing table TEST_TABLE_MAIN Question1) Th…
-
Select AI With RAG - AI Profile attribiutesHello, I have a query regarding the Creating AI Profile for Oracle Select AI with Retrieval-Augmented Generation (RAG). Specifically, I am curious about the behavior whe…
-
how to create ords api to send file as a multipart attachment in requestSummary: Hi Experts How to create a ORDS REST API to send a file as a multi part form data and insert into a table column of blob type. Please help me. I do not want to …
-
How to create a read-only user in an ATP databaseSummary: Our customers request to create read-only users in the ATP databases they have, basically they want to have a user who can only inquiry tables and check databas…
-
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 …
-
[URGENT] Please move all Always Free 21c instances to 23ai as soon as possible!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 21c datab…
-
Need to call DBMS_CLOUD but EXECUTE grant was removedSummary: One of our customers has two ATP instances with DBMS_CLOUD, they have several PL/SQL packages where they call DBMS_CLOUD without issues until last week where in…
-
A quick recap of ADB announcements at CloudWorld Las VegasA quick recap of ADB+GenAI announcements from CloudWorld Las VegasA couple of weeks ago we held our annual customer conference in Las Vegas. During the event, there were…
-
Issues running Oracle Apex on ATPSummary Apex shows blank page when trying to access via tools menuContent Hi,I have an Autonomous Transaction Processing Database instance set up on the Oracle cloud. Th…
-
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…
-
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…