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 - Changes to Password Rules for non-ADMIN usersContent For non-admin users the password length has been lowered from 12 to 8 characters. Rules for covering passwords for ADMIN user are unchanged. -
GA ANNOUNCEMENT - Oracle Cloud Infrastructure Events IntegrationContent You can now use OCI Events to subscribe to, and be notified of, Autonomous Database events. Using OCI Events you can create automation and receive notifications …
-
ADB Object Deployments - Hub and Spoke configurationSummary ATP database (hub) control one or more ADW databases (spokes) with regard to object deployments for things like views\MVs and proceduresContent Hi All, I was loo…User_2025-02-08-03-47-01-847 24 views 0 comments 0 points Most recent by User_2025-02-08-03-47-01-847 -
GA ANNOUNCEMENT - Oracle Cloud Infrastructure SDK for PL/SQLContent The Oracle Cloud Infrastructure SDK for PL/SQL enables you to write code to interact with Oracle Cloud Infrastructure resources, including Autonomous Database. T…
-
GA ANNOUNCEMENT - Change ADB Mode to Read/Write or Read-OnlyContent It is now possible to select an Autonomous Database operation mode - the default mode is Read/Write. If you select Read-Only mode users can only run queries. In …
-
GA ANNOUNCEMENT - ADW Tools Now Support Private EndpointsContent Oracle Application Express, Oracle SQL Developer Web, and Oracle REST Data Services are now supported in Autonomous Databases with private endpoints. It is possi…
-
"Update Network Access" option is not available in the Autonomous databaseSummary "Update Network Access" option is not available in the Autonomous databaseContent Hi, I want to change the network access type of an Autonomous Database on share…
-
Connect Oracle Autonomous Database in Microsoft Azure Data FactoryContent Anyone in here have already connected Oracle Autonomous DB in Azure Data Factory? We are trying to implement some data copies from SQL Server to Oracle, but I am… -
VPD on Autonomous Data WarehouseSummary How to Run Queries as VPD USERContent If I am and Admin want to set an user as VPD user...is there any way to do it? I was looking at google and found 'exec vpd.…
-
DBMS_CLOUD.VALIDATE_EXTERNAL_TABLE unable to see validation errorsSummary Unable to see validation errors in either VALIDATE$21_LOG or VALIDATE$21_BAD tablesContent I have successfully created an external table in my schema, but when I…User_2025-02-08-03-47-01-847 36 views 9 comments 1 point Most recent by User_2025-02-08-03-47-01-847
-
Unable to import APEX ApplicationSummary Unable to import APEX ApplicationContent I really hope you can help me, I need to import a backup of my Apex application, but I'm getting an error when trying to…
-
Automatically loading a file from Object Storage on ArrivalSummary Automatically loading a file from Object Storage on ArrivalContent Hi, I hope you are all well. Our on-premise data warehouse receives files into the file system…User_2025-02-08-03-47-01-847 31 views 2 comments 0 points Most recent by User_2025-02-08-03-47-01-847
-
How to get physical queries along with VPD PredicatesSummary How to get physical queries along with VPD PredicatesContent We are planning to use VPD for security, but one of the issue that we are finding is, HOW to get the…
-
How to delete files in a directory after dropping the directory objectSummary How to delete files in a directory after dropping the directory objectContent Hi guys, I created a directory object and copied a file into it from an object stor…User_2025-02-01-05-36-16-781 196 views 0 comments 0 points Most recent by User_2025-02-01-05-36-16-781
-
How to delete a manual backup in ATP databaseSummary How to delete a manual backup in ATP databaseContent Hi, I have successfully configured an object storage to make it target for my autonomous database. My questi…User_2025-02-01-05-36-16-781 18 views 0 comments 0 points Most recent by User_2025-02-01-05-36-16-781
-
ADW APEX - 503 Service UnavailableSummary Unable to connect to ADW from APEX or SQL Developer - ORDS Error 503 Service UnavailableContent Hi, I hope you are all well. I am having trouble accessing my ADW…User_2025-02-08-03-47-01-847 104 views 16 comments 2 points Most recent by User_2025-02-08-03-47-01-847
-
Unable to start the db after recoveryContent Hi guys, I tried to restore my ATP database in specific point of time, but it failed and reported the following error: The Autonomous Database operation failed d…User_2025-02-01-05-36-16-781 25 views 0 comments 0 points Most recent by User_2025-02-01-05-36-16-781
-
Register XML SchemaSummary Is DBMS_XMLSCHEMA available in Autonomous Database?Content Hi, I hope you are all well. I am trying to register an XML XSD within my autonomous database, but I'm…
-
Will the trial-credits be used after upgrading an Autonomous database to paid service?Summary Will the trial-credits be used after upgrading an Autonomous database to paid service?Content Hi guys, When I upgrade an always-free autonomous database to a pai…
-
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…User_2025-02-11-02-32-53-000 28 views 2 comments 0 points Most recent by User_2025-02-11-02-32-53-000
-
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 admin@db202003031036_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:…