Autonomous Database
Discussion List
-
Import ErrorSummary Error when importingContent Dear Friends When importing data from 12c to Cloud ATP I am getting the below error for some rows where Arabic data is there. KUP-110…
-
Does using Oracle Safe on Autonomous Database add extra chargesSummary Does using Oracle Safe on Autonomous Database add extra chargesContent Hi guys, I understand that Oracle Autonomous Database has its own auditing capabilities an…
-
Oracle Cloud ATP database missing under ATP section in Oracle CloudSummary ATP database stopped for unknown reasons and unable to startContent when i tried accessing one of my APEX applications I developed on oracle cloud. I get this er…
-
A working example of UTL_HTTP.REQUEST, please!Summary Please provide with a complete example of UTL_HTTP.REQUEST, which works on ATPContent I am totally stuck with my inability to make an API call from PL/SQL runnin…
-
utl_http.request on 19c getting Certificate Failure. works on 18cSummary utl_http.request on 19c getting Certificate Failure. works on 18cContent Using Always Free ATP I currently can only provision 18c DB. Two weeks ago I provisioned…
-
Can we connect to REST API using External Table from within ADW?Summary Would like to know if there is a way to create an external table to connect to REST data source?Content As I understand from this post: https://cloudcustomerconn…
-
Changing Home Region for Oracle CloudSummary Changing home region and unsubscribing old regionContent Hi, Currently,we are running on UK region and that is our home region But now we have subscribed Saudi a…
-
Trying to do an IMPDP to ATP and getting error: ORA-06508: PL/SQL: could not find program unit beinSummary From my compute node, trying to user either IMPDP or EXPDP to import / export, but getting an errorContent expdp [email protected]_high schemas=vrs dumpfile=e…
-
GA ANNOUNCEMENT - SQL Macros now available in Autonomous Data WarehouseContent What is a SQL Macro? It is a new and unique way for SQL developers to encapsulate complex processing which can then be reused within SQL statements. Unlike bespo…
-
GA ANNOUNCMENT - Refreshable clones now availableContent Autonomous Database provides cloning where you can choose to create a full clone of the active instance, create a metadata clone, or create a refreshable clone. …
-
Autonomous Database Newsletter - September 03, 2020Content Welcome to our latest customer newsletter for Autonomous Database on Shared Exadata Infrastructure. This newsletter covers the following new features and topics:…
-
APEX - Unable to log into Application "404 Not Found"Summary Getting Rest Data Services "404 Not Found" error when trying to log into any of the Apex applications I have created on Autonomous Data WarehouseContent Hi all, …
-
Oracle APEX is not updgraded to 20.1Summary Oracle APEX is not updgraded to 20.1Content Now, its been 45 days and my always free tier instance has not been upgraded to latest version 20.1 even after 45 day…
-
Free cloud trials link, does not workSummary I try to enter on the free cloud trials link and i get and error page does not existsContent I try to enter on the free cloud trials link and i get and error pag…
-
Unable to Login into Oracle APEX from my ATP DBSummary Unable to login into workspace in Oracle APEXContent I am unable to login into Oracle APEX after recent upgrade to 20.1. I get invalid credentials. I am able to …
-
NOW AVAILABLE - ADW Training Plans For LiveLabsContent We have launched a new page on oracle.com to help you navigate all the data warehousing workshops available within LiveLabs. Select the main topic area, then eit…
-
GA ANNOUNCEMENT - Oracle Analytics Cloud 5.7 now supports ADB machine learning modelsContent Machine learning models in Oracle Autonomous Database can now be registered in Oracle Analytics Cloud. These can then be applied to datasets and data connections…
-
GA ANNOUNCEMENT - Data Safe Now Supports ADBs Using Private EndpointsContent You can now register an Autonomous Database on Shared Exadata Infrastructure within a private virtual cloud network (VCN). For Oracle Data Safe to communicate wi…
-
GA ANNOUNCEMENT - Change Database Name For An Autonomous DatabaseContent Autonomous Database offers quick and easy provisioning which is an integral part of an agile development framework. This agility can be further accelerated with …
-
Geocoding in Autonomous DatabaseSummary ORA-29538: Java not installed when trying to call MDSYS.SDO_GCDRContent Hi, I hope you can help as I couldn't find any support on google for my particular issue …
-
DBMS_CLOUD.CREATE_EXTERNAL_TABLE handling accent marks in textSummary KUP-04021: field formatting error for field ADDRESSLINE1 when loading external table where text string contains special charactersContent Hi, I'm hoping you can …
-
Loading XML data into databaseSummary How to load a CSV file into database that contains a field with XML dataContent Hi, I'm hoping you can help. I have a CSV file containing textual and XML data, a…
-
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'…
-
APEX suddenly 404s with "The request could not be mapped to any database"Summary I have a free ATP instance and sudden neither the APEX nor the SQL Developer link workContent I have a free instance of Autonomous Transaction Processing. I have…
-
ORDS not working at Frankfurt siteSummary ORDS not working at Frankfurt siteContent Hi, have somebody an idea why ORDS / APEX isn't working at Frankfurt site? I get the error 404 when calling the URL of …
-
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…
-
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.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…