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
-
DBMS_CLOUD.CREATE_EXTERNAL_TABLE ignoring NULL columns tab delimited fileSummary External table is ignoring NULL columns on tab delimited file so contents are appearing in wrong columnsContent I have created an external table over a tab-delim…User_2025-02-08-03-47-01-847 23 views 4 comments 0 points Most recent by User_2025-02-08-03-47-01-847 -
How to Manually Upgrade Your ADW Instances From 18c to 19cContent In a recent newsletter (April 08, 2020) I mentioned that Oracle Database 19c is now available on Autonomous Database for all regions. The default version for all… -
DBMS_CLOUD.CREATE_EXTERNAL_TABLE file delimiter "+|"Summary Trying to setup an external table for a file which is delimited by "+|" and row delimited by "&|" but failing on validationContent Hi, I hope you can help me. I'…
-
dbms_cloud.copy_data gives ORA-20404: Object not foundSummary Following "Oracle by Example" tutorial yields above error.Content On this page: https://www.oracle.com/webfolder/technetwork/tutorials/obe/cloud/atp/obe_loading_… -
Newsletter for Autonomous Database on Shared Infrastructure (July 22-2020) is now availableContent Latest newsletter for Autonomous Database on Shared Infrastructure (July 22-2020) is now available on the Data Warehousing blog: https://blogs.oracle.com/datawar…
-
GA ANNOUNCEMENT - ADW Deployment Patterns in OCI Resource ManagerContent The list of pre-built Stacks within OCI Resource Manager has been expanded to include some of the new reference architecture patterns that support this year's Mo…
-
GA ANNOUNCEMENT - Autonomous Data Guard now availableContent When you enable Autonomous Data Guard on ADB, the system creates a standby database that stays "connected" to the primary database and automatically refreshes it…
-
Unable to delete Old Version Apex Schema from ATP DatabaseSummary Unable to delete Old Version Apex Schema from ATP DatabaseContent Hi, I found that every time APEX is upgraded in ATP Database, the old apex schema is not delete…User_2025-02-08-09-03-28-606 35 views 4 comments 0 points Most recent by User_2025-02-08-09-03-28-606
-
Oracle Autonomous Transaction Processing Cloud Paid Option of 100GB and 1vCPU should be availableSummary Very Wide Gap between Oracle Autonomous Transaction Cloud Always Free and nearest paid optionContent There is always Free Oracle Autonomous Transaction Processin… -
What are these sessions?Content Hi, I have this ATP and I do no development at this time. But I monitor unknown sessions in my database. (see attachement). What is that? Regards
-
You do not get what they promiseContent Hi, Oracle offers 2 Always free 2 Autonomous Databases (Autonomous Data Warehouse or Autonomous Transaction Processing), each with 1 OCPU and 20 GB storage. But …
-
GA ANNOUNCEMENT - Create/Modify User Profile and Set Password RulesContent Autonomous Database now supports the ability to create/alter user profiles and import existing user profiles from another environment with Oracle Data Pump Impor…
-
GA ANNOUNCEMENT - Timezone Files Automatically UpdatedContent For time zone support, Oracle Database uses time zone files that store the list of all time zones. The time zone files for Autonomous Database are periodically u…
-
GA ANNOUNCEMENT - Modify Network Settings for Existing ADB InstancesContent Autonomous Database now supports switching network access type. This feature enables customers to perform an in-place switch from public endpoint to private endp…
-
GA ANNOUNCEMENT - ADB Supports Connecting to non-Oracle DatabasesContent Autonomous Database now supports using connections that are enabled via Oracle Database Gateway. Gateways are designed for accessing a specific non-Oracle Databa…
-
APEX - Creating page based on SaaS REST API. HTTP-400 Bad Request on update.Summary Created a page based on the SaaS Suppliers RESTful API. Retrieving row works fine, HTTP-400 when I try and update oneContent Hey folks I'm trying to create an AP…
-
DBMS_CLOUD Insufficient PrivilegesSummary Insufficient Privilege errors while using EXPDP and DBMS_CLOUDContent Hi, earlier this year I've setup a free ATP database and setup a small backup script which …
-
Can I create a Java Stored Procedure on an Autonomous DB?Summary Getting error "ORA-29538: Java not installed" when trying to create a java procedure in the DBContent Hi all, I'm getting the following error (below) when creati…
-
ORA-29261: bad argumentSummary Loging in to any workspace results in a ORA-29261: bad argumentContent When I try to login to my Oracle Free Cloud Apex, it always results in a "ORA-29261: bad a…
-
503 Service Unavailable java.sql.SQLRecoverableException: No more data to read from socketSummary Cannot access Oracle Apex on ATP Always Free LicenseContent Hi! My Oracle ATP on Autonomous suddenly stopped running. Facing ORDS error 503 Service Unavailable. …
-
ORA-02002: error while writing to audit trailSummary Not able to connect to free OTPContent I am getting: ORDS was unable to make a connection to the database. This can occur if the database is unavailable, the max…
-
Newsletter for Autonomous Database on Shared Infrastructure (June 24-2020) is now availableContent Latest edition of the newsletter for Autonomous Database on Shared Infrastructure (June 24-2020) is now available here: https://blogs.oracle.com/datawarehousing/…
-
GA ANNOUNCEMENT - Reference Architecture Patterns and Solution Playbooks Now AvailableContent The Architecture Center has been u[dated to include a new series of data warehouse patterns: Each reference architecture pattern will come with the following: be…
-
GA ANNOUNCEMENT - Procedures For Using Database Real Application Security With ADBContent Real Application Security works the same on Autonomous Database as on an on-premise database except you need to perform some additional administrator tasks befor…
-
GA ANNOUNCEMENT - Maximum File Size Increased For Transfer Object StoreContent The maximum file size limit for DBMS_CLOUD.PUT_OBJECT procedure when transferring files to OCI Object Storage has been increased to 50 GB. Note - there are diffe…
-
GA ANNOUNCEMENT - Download AWR Reports From Performance HubContent Automatic Workload Repository (AWR) report is a vital tool to collect historical performance statistics of an Oracle Database by DBAs and System Performance engi…
-
GA ANNOUNCEMENT - ADW now supports ORC filesContent ADB has expanded object storage support in two important ways: it can now query ORC files as well as complex data types found in Parquet, ORC and Avro files. ORC…
-
No Primary Key item has been defined for form regionSummary Clicking button to new page causes internal APEX errorContent Hi Gurus, I'm getting an error when clicking a button to go to a new page for a simple registration… -
Error: SyntaxError: Unexpected end of JSON inputSummary Unable to view or edit Apex page in Page designerContent When clicking on a page in the page designer to edit the page the error occurs. The error also occurs wh…
-
ADW API deprecationSummary How to find the ADW API's in my environment - Deprecated Autonomous Data Warehouse APIsContent We got a notification from Oracle regarding 'Autonomous Database A…