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…
-
ADB Maintenance in PHXSummary: Email regarding ADB deployments in PHX Dear Customer, Oracle Autonomous Database (ADB) will be performing scheduled maintenance on your ADB instance(s), located…
-
what are the timings for Planned Network Maintenance on located in the phoenix datacenterSummary: what are the timings for Planned Network Maintenance to improve connectivity and network performance located in the phoenix datacenter on 27th and 28th Septembe…
-
create database system standalone free failedSummary: I've tried twice to create a standard always-free database system, and both times it ends in a "failed" state with no error message displayed. I have the resour…
-
Issue with OCI Notifications (DBMS_CLOUD_NOTIFICATION.SEND_MESSAGE)Summary: Issue with OCI Notifications (DBMS_CLOUD_NOTIFICATION.SEND_MESSAGE) Content (please ensure you mask any confidential information): I am attempting to setup OCI …
-
How to create OCI load balancer for ADB-D dedicated database in private networkSummary: How to create OCI load balancer for ADB-D dedicated database in private network. Which IP's need to be defined for backend of OCI LB. Content (please ensure you…
-
How to connect to ADB dedicated database in private network from sql developerSummary: How to connect to ADB dedicated database in private network from sql developer. We have allowed the bastion private endpoint to access the DB port 1521 from dat…
-
How to connect to ADB-D database in private network from VBCSSummary: How to connect to ADB-D database in private network from VBCS.? We have a created load balance for port tls (ssl) port and public IP was modified in tnsnames.or…
-
how to create a load balancer for autonomous dedicated database ORDS in OCISummary: how to create a load balancer for autonomous dedicated database ORDS in OCI. We have a autonomous dedicated database created in private subnet and need to creat…
-
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…