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
-
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…
-
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…
-
TEST performance of an APEX aplicationWe need to observe the performance of an ORACLE APEX application. Metrics like: • Largest Contentful Paint (LCP) • First Contentful Paint (FCP) • Cumulative Layout Shift… -
Oracle Learning Lounge Webcast: Oracle Database 23ai - JSON-Relational DualityDATE: March 18, 2025 TIME: 9:00 AM - 10:00 AM US/Pacific Join Oracle’s renowned Julian Dontcheff (Distinguished Product Manager, PL/SQL and JSON) for an exclusive Learni… -
Issue connecting to 23ai autonomous data warehouse "Always Free" instance - ORDS HTTP Status 571Summary: Due to 21c "Always Free" instances being imminently decommissioned, I rebuilt a database in 23ai. The original 21c database was an APEX instance, and I decided …
-
Modification/Manual Allocation of Default Consumer Group Concurrency and DOP in ADW?Summary: Is it possible to modify the default concurrency and DOP provided within the pre-set consumer groups in ADW? For example, if you do not need as much concurrency…