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
-
GA ANNOUNCEMENT - Networking QuickStart WizardSummary The OCI network team has announced the general availability of a new Networking QuickStart wizard.Content The OCI network team has announced the general availabi… -
GA ANNOUNCEMENT - Partitioned External Tables now support Parquet and Avro FilesSummary CREATE_EXTERNAL_PART_TABLE procedure now supports both Parquet and Avro files formats.Content CREATE_EXTERNAL_PART_TABLE procedure now supports both Parquet and … -
Error in loading an application page in APEX Builder on ATPContent Hello! Last couple of weeks when I open APEX through OCI, ATP db, Any page of any application is not loaded in the App Builder. Error is: SyntaxError: JSON.parse… -
503 on REST and APEX services with ACL enabledSummary When ACL's are enabled on the database the REST and APEX services are unavailableContent Hi, struggling a bit with the understanding of the ACL's. According to t… -
Not able to connect to Autonomous Database using sqlplusSummary Not able to connect to Autonomous Database using sqlplus or tnsping Content I created an Autonomous Database, transaction processing workload, serverless deploym…User_2025-02-06-06-01-49-041 33 views 2 comments 0 points Most recent by User_2025-02-06-06-01-49-041 -
How can I reduce storage utilization?Content Even after I drop my table including recyclebin, storage utilization shown on Service console won't be decreased. How can I reduce storage utilization? -
Rename schema in ATP?Summary How can a schema be renamed? Content When I started using the cloud ATP system, I used what is likely the default schema of "WORKSPACE_1". How do I rename that? … -
Oracle Cloud stopping due to inactivitySummary Oracle Cloud stopping due to inactivityContent I have an Oracle Cloud Autonomous Database running in the Free Tier. Occasionally the database stops. When viewed …User_2025-02-06-06-01-37-824 54 views 8 comments 0 points Most recent by User_2025-02-06-13-16-25-165 -
Not able to access bad file created by DBMS_CLOUD.validate_external_tableSummary KUP-04040: file VALIDATE$137_320200.bad in DATA_PUMP_DIR not foundContent We are trying to validate external table using dbms_cloud.validate_external_table proce… -
How to connect standalone ORDS with ATP database?Summary How to connect standalone ORDS with ATP databaseContent Hello, I have created OC Instance with installed ORDS (run as standalone). I have created ATP Database, w…User_2025-01-31-02-31-54-062 31 views 2 comments 0 points Most recent by User_2025-01-31-02-31-54-062 -
Autonomous Database and timezoneSummary how to change a timezone in an Autonomous DatabaseContent i use the parameter TIME_ZONE but the value don't change Oracle Database 18c Enterprise Edition Release… -
GA Announcement: SQL Developer Web now supports data loadingSummary ADB Serverless has been updated with SQL Developer Web 19.2.1. SQL Developer Web now supports loading data into an existing table.Content ADB Serverless has been… -
Registering own schema to publish custom packages on Oracle database in ATPSummary ORDS, ATP databaseContent We have created ATP database. In the database, we created new schema called YOUR_APP_SCHEMA and create HR tables. We registered schema … -
Testing before patching with ATP-S(Serverlss)Content I'm looking for the way to testing my application to see if there is any nagative impact due to patching before patch is applied with ATP-S(Serverless) instance.… -
Character code selectionSummary Is there a plan to be able to select the character code.Content Currently we can select only utf8 as a character code on Autonomous DB. Is there a plan to be abl… -
Getting ORA-12154 error while connecting from SQL developer to Autonomous DBSummary I have setup my ADB successfully and able to connect to it from local windows 10 machine using connection type as wallet. However, when I try from SQLPLUS and us… -
autonomous data warehouse shows incorrect storage usageSummary autonomous data warehouse shows incorrect storage usageContent Hi, the overview page (service console) of my autonomous data warehouse shows a usage of 9.82 GB. … -
Connect to autonomous database from jersey serviceSummary How to connect to an autonomous database from a jersey service? -
GA Announcement: Support For Hybrid Partitioned Tables Now Available (19c Preview only)Summary Support For Hybrid Partitioned Tables Now Available (19c Preview only)Content Hybrid partitioned tables allows a query to access both internal data and multiple … -
GA Annoncement: Support for External Partitioned Tables Now AvailableSummary This new feature, external partitioned table, creates the ability to query multiple data files in the Object Store as a single external tableContent This new fea… -
GA Announcement: Customer Managed Wallet Rotations Now AvailableSummary GA Announcement: Customer Managed Wallet Rotations Now AvailableContent This new wallet rotation feature makes it easy for customers to invalidate existing clien… -
GA Announcement - Database-Specific Wallets Now AvailableSummary GA Announcement - Database-Specific Wallets Now AvailableContent On the Database Connection form, it is now possible to select type of wallet that will be genera… -
ORDS CRUD Generator tool on ATP / APEXSummary I've made a CRUD Generator tool that can create an SQL script that creates a complete CRUD operation and a PATCH procedureContent I would like to share something… -
Is ORDS authentication (first-party basic) with ATP & APEX possible??Summary When using ORDS out-of-the-box included in ATP & APEX we cannot get basic authentication to workContent Hi all, We are running into the following problem. We hav… -
Apex and SQL Developer Web on ATP 19c previewSummary Getting error trying to start either Apex or SQL developer Web on ATP 19c previewContent Here is the error when I try to open Apex 503 Service Unavailable * The … -
Passing parameter value conditionallySummary Passing parameter value conditionally in ORDS RESTContent Hi, I have a simple requirement where in I want to pass a variable value in query parameter to ORDS RES…User_2025-02-04-06-54-05-326 17 views 0 comments 0 points Most recent by User_2025-02-04-06-54-05-326 -
imdbSummary is imdv available on ATP?Content hi all, I'd like to cache some table using technology like imdb (TimeTen) is this possible on DBaaS -
ADB in Region Germany Cental (Frankfurt) how to set a proper SYSDATE?Summary ADB in Region Germany Cental (Frankfurt) how to set a proper SYSDATE?Content Hi, My ADB is located in Region Germany Central (Frankfurt). However, the SYSDATE of… -
Invalid Package in SYS schemaSummary PACKAGE BODY DBMS_XSTREAM_GG_ADM in SYS SCHEMA IS INVALIDContent PLEASE COMPILE PACKAGE BODY SYS.DBMS_XSTREAM_GG_ADM in my ATP INSTANCE. My instance_name is : es… -
SSB userSummary star schemaContent hi all Oracle autonomous has a SSB schema , its an example of star schemas , but the oracle schema is locked. From our admin user it is not po…