Category 245
Discussion List
-
ATP DB Schema RenameSummary: I am seeking your expert advice on a significant change that we are planning to take. Could you kindly share any recommendations regarding the following scenari… -
Authentication of Accessing ATP DB objects in OIC without storing creds in OIC ConnectionWe have an ask from one of our client's IT security team that we do not store the ATP wallet and credential details within the OIC connection. Instead, is there a way to…
-
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…Iker Garcia Martin 154 views 4 comments 0 points Most recent by Iker Garcia Martin Autonomous Database
-
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 … -
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…
-
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…Humberto Martín-Oracle 144 views 1 comment 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
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 …Keith Laker-Oracle 131 views 22 comments 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
[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…Keith Laker-Oracle 241 views 18 comments 1 point Most recent by Keith Laker-Oracle Autonomous Database
-
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…Humberto Martín-Oracle 31 views 2 comments 0 points Most recent by Humberto Martín-Oracle Autonomous Database
-
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…
-
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?Jonathan Ivani-Oracle 21 views 0 comments 0 points Started by Jonathan Ivani-Oracle Autonomous Database
-
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…Debadrita Ghosh-Oracle 32 views 1 comment 0 points Most recent by Keith Laker-Oracle Autonomous Database