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
-
Webcast: Innovate in your favorite Dev languages - Top 10 ADB features and demosReady to innovate without switching stacks? 🚀 Join us today, July 15 at 9 AM PT, in the Autonomous Database Learning Lounge for a power-packed session with Oracle expert… -
23 reasons why you need to be at this year's CloudWorldDon't miss out on the opportunity to transform your data strategy and accelerate your AI journey. Our guide provides a detailed preview of the expertise, innovation, and…
-
May's latest new feature announcements for Autonomous DatabaseSummary: As May comes to a close, here is information about the new features released during the last 2 weeks along with some customer success stories. Don't forget to s…
-
Cannot SSH to instance & How to connect to the ATP from linuxContent Problem: I am getting error when I try to SSH to the instance from Mac computer. IP address and the user id that I am using were provided on the Instance Detail … -
ANNOUNCEMENT: February's newsletter covering all the latest new features in Autonomous DatabaseList of all the new features recently added to Autonomous Database (too many to list) in our regular "What's New" newsletter - https://blogs.oracle.com/datawarehousing/p…
-
Does the ALL_MINILM_L12_V2 model in database 23ai train any LM using our data?I am experimenting with Oracle Database 23ai using the Oracle delivered all_MiniLM_L12_v2.onnx model. I have the model loaded into the database and a test table created …
-
Autonomous Transactional Database (ADB) - Customer Managed Key rotationHi Experts, we are using ADB 19c PaaS service and used customer managed key while spinup instance. As per security policy we need to rotate encryption key and need clari…
-
Autonomous Database in-place uprgade to 23ai now availableHi folks, We are please to announce the ability for users to perform an in-place upgrade on 19c databases to 23ai. Users have two simple options to schedule an upgrade: …
-
Shrink tablespace DBFS_DATA on Always Free Autonomous DatabaseSummary: Hi Team, I basically have the same issue mentioned here After I ran my dbms_datapump job to export my database, the job failed with the below error message: ORA…
-
Autonomous database upgrade 19c to 23aiSummary: Hi We have a set of ATP/ADW instances that are in 19c and should be upgraded to 23ai version. Please advise what are the options and things to consider/risks/is…
-
How can we import exported ATP "Data Transforms" project?We've created a data transforms project in our development database and exported it. I need to import project into production environment, but there is no import option … -
Chronological Bar Charts in APEX 21.1.7I have a view which has 3 columns, one of which is TO_CHAR formatted from TO_DATE as MON-YY. This feeds into an APEX bar-chart, which is ordering the bars alphabetically…
-
What are some good strategies for optimizing performance of object store based data/delta shares?Summary: Working on stress testing performance of the object store based data/delta shares (specifically using the provided LINE_ORDER sample data ~600 Billion records).…
-
how can you download apex patch images folderSummary: If you are using APEX in OCI free autonomous database with cutomer maintained ORDS vm frontend. How do you get a copy of the apex images folder for the point re…
-
oracle autonomous database on free tier - account lockedSummary: Cannot access Database Actions on my OCI tenancy. Content (please ensure you mask any confidential information): I use an Oracle free tier Autonomous Database o…
-
Time Zone Date in APEX ApplicationSummary: when query about current time zone in SQL Workshope of oracle Apex by : select CURRENT_TIMESTAMP from dual; Apex Application Setting when set default value by :…
-
Can we build the APEX application on AWS RedShiftCan we build the APEX application on AWS RedShift or Microsoft SQL Server Developer (64-bit) database?
-
How do I configure application continuity for ADW-S (Serverless)?Summary: We are running the Oracle Integration PaaS Service. It connects (via the default ADW wallet) to an ADW-S DBaaS Sevice. When the ADW service is patched (weekly o… -
Cannot start Oracle Autonomous Database because its resource plan does not existSummary: Hello! I'm not sure if this is the right place to ask (never asked a question on Oracle Community before), but this seems to be where my OCI interface leads me … -
How to setup notifications for planned maintenance on Autonomous Database Serverless Services?Hi Everyone! We have several DBaaS Autonomous Database services (ADW-S). Each week, these services are updated, by Oracle, on a regular schedule. Within OCI, on the Auto…
-
How to insert comma delimited values in one column using DBMS_CLOUD?Summary: Hi Team, We are trying to insert the bulk data using DBMS_CLOUD_COPY_DATA/DBMS_CLOUD.CREATE_EXTERNAL_TABLE. In source file, We have few columns like tags/additi…
-
Can a consumed data share be subsequently shared out?For example: If I'm consuming a databricks datashare, that results in a external table/view in ADW, can I then configure that external table/view to be a part of a ADW d…
-
DBMS_SHARE.CREATE_SHARE_LINK_VIEW failing with ora-20863Summary: I've set up a share link to a share provide that I've confirmed can be authenticated to by running: SELECT *FROM DBMS_SHARE.DISCOVER_AVAILABLE_TABLES(share_prov…
-
The clock time on my autonomous database is wrongSummary: The clock time on my autonomous database on OCI free in LONDON is 2 minute slow. I have a friend who has an instance in Cardiff data centre and if we issue the …
-
URGENT: Database Connection Error HTTP Status Code: 571Sorry for the duplication —> https://community.oracle.com/customerconnect/discussion/871055/database-connection-error-http-status-code-571 Summary:Oracle ATP - Free Tier…
-
Need to shrink tablespaces after datapump: ORA-65114 (Always Free APEX)Summary: I have basically the same issue as this other thread: I created schemas with my tables and data from datapump exports (using object storage and dbms_cloud). A t…
-
Serial APEX WorkflowSummary: How to build serial approval in Apex workflow Specially if there is near 6 to 7 levels of approvers Content (please ensure you mask any confidential information…
-
Add attachement when create task definationSummary: Is it possible to add attachement when create task defination in oracle apex work flow Content (please ensure you mask any confidential information): Version (i…
-
powerbi desktop connecting to Oracle Autonomous DatabaseSummary: I need to get data in Microsoft PowerBI from Oracle Autonomous Database. And I got this error. Does not look like I can establish the Oracle Autonomouse Databas…
-
DPY-6000: Listener refused connectionSummary: Unable to connect to ATP DB via Python code DPY-6005: cannot connect to database (CONNECTION_ID=""). DPY-6000: Listener refused connection. (Similar to ORA-1250… -
Oracle EPM as Data Source for APEXHas anyone successfully configured an Oracle EPM application as a REST Data Source for APEX? Any tips or advice would be much appreciated… I see SaaS as a data source ty… -
Oracle ATP database shows column - cloud_maintained what does it mean?Oracle ATP database shows column - cloud_maintained What does this column mean? This column is visible when running query against a Oracle ATP database in oci: select * …
-
service gatewayquestion very interesting and urgent!! The Service Gateway allows private traffic between resources in a VCN and public services of OCI but of other tenancies? The Servi… -
Ajax call returned server error ORA-01840: input value not long enough for date formatSummary: today i am getting the following error when passing a page item value (date picker) from one page to another page. It has never happened before. It is a strange…
-
ORA-20401: Authorization failed for URI using dbms_cloud access to object storageSummary: Getting authorization failed error connecting to the object storage from oci base 23 ai db. ORA-20401: Authorization failed for URI - https://objectstorage.us-c…