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
-
how to write a file using a query in atp databaseSummary how to write a file using a query in atp databaseContent how to write a file using a query in atp database and have that file stored in object storage area. rega…
-
Get 503 Service Unavailable when trying to access APEX or SQL Dev WebContent Created two new ATP databases Always Free today. One works fine the other fails when trying to access APEX or SQL Dev Web: 503 Service Unavailable 2021-03-03T01:…
-
to integrate MS SQL Server dB with ADWContent Can we integrate SQL Server dB with Oracle ADW using Oracle Application Integration where operations like POST,GET,PUT can take place between ADW and SQL Server …
-
Accessing ADW without using APEX or SQL Dev tool to create REST APIsContent Hi team, Can we access Oracle ADW through some other tools and by not using its own components like Oracle APEX or Oracle SQL Web Developer tool to make REST API…
-
How install Sample Schemas?Summary Old instructions for installing Sample Schemas don't apply to ATPContent Can the Sample Schemas be installed on an ATP database? The documentation shows a proces…
-
Oracle DataSafe Product Enhancement IdeasSummary Oracle DataSafe Product Enhancement IdeasContent Hi Team, We have been using Oracle DataSafe on ADW for sometime now. We use Data Masking functionality extensive…User_2025-02-10-16-52-46-302 25 views 2 comments 0 points Most recent by User_2025-02-10-16-52-46-302
-
SM/ADVISOR Occupies almost all Storage on Always Free ATP DBContent I have created a free tier ATP database some time ago. Recently, I note that almost all space (out of the 20GB available) were occupied by Oracle automated jobs,…
-
ORA-01652 on Shared ATP - is there an upper limit on TEMP tablespace allocation?Summary Curious what the upper limit is (if known)Content Update - will move to an internal forum - my apologies. We are technically a cloud customer (albeit internal) a…
-
Can I delete specific manual backup?Summary Can I delete specific manual backup?Content Hi, If I created multiple manual backups for an autonomous database, is there a way to delete one of them and keep th…
-
To extract hostname, port name, service name from Oracle Autonomous Data WarehouseContent How can we extract hostname, portname , service name of Oracle ADW cloud as we are trying to connect a database using Python scripts and the Python script is dem…
-
Getting 404 error when trying to access SQL Developer Web from Autonomous Database Service ConsoleContent Hi, I have been using an Autonomous ATP Database since the end of last year. I had connected to this database via SQL Developer Web from the service console as r…
-
To generate each rows with unique IDs (primary key) in ascending orderContent I am inserting values inside ADW in Oracle Apex through REST API parameters. I am able to get unique values but the order is getting random after inserting two r…
-
Clone Apex SessionSummary I clone Apex Session in local Database 18c XE and work fine, but on the Cloud not Work.Content Hi, I need to clone the Apex session to the Oracle Cloud Free Tier…
-
Custom SortSummary I want to be able to custom sort based on a dimension but do not want it alphabeticalContent I have a status that I am wanting to sort by "At Risk," "Potential I…
-
Is it possible to use apex_web_service.make_rest_request in Oracle Apex in Oracle Cloud Always Free?Summary Trying to make an external call to a REST web service from Oracle Apex in Oracle cloud and getting ORA-20987Content I am making a REST request to an External API…
-
When full backup is taken?Summary When full backup is taken?Content Hi guys, When I checked the automatic backups taken for an autonomous database, I noticed all of them are incremented. When was…User_2025-02-01-05-36-16-781 14 views 4 comments 0 points Most recent by User_2025-02-01-05-36-16-781
-
Can I restore a terminated DB from manual backup?Summary Can I restore a terminated DB from manual backup?Content Hi, I have a backup taken manually for an autonomous database. Can I use it to restore the database, if …User_2025-02-01-05-36-16-781 28 views 2 comments 0 points Most recent by User_2025-02-01-05-36-16-781
-
Can I restore from old backups?Summary Can I restore from old backups?Content Hi, I understand that the autonomous backup taken automatically are kept for 60 days. If I have a manual backup for an aut…User_2025-02-01-05-36-16-781 6 views 2 comments 0 points Most recent by User_2025-02-01-05-36-16-781
-
My always free database is always StoppedSummary I start the database on the OCI but after few minutes it goes Stopped againContent Hello. I am using the Always Free database since February. I has been working …
-
December Newsletter for Autonomous Database Now AvailableContent December newsletter for Autonomous Database on Shared Exadata Infrastructure is now available and covers the following new features and topics: * Release of APEX…
-
GA ANNOUNCEMENT - Oracle Cloud Infrastructure Operations InsightsContent Oracle Cloud Infrastructure Operations Insights provides 360-degree insight into database resource utilization and capacity. It is FREE to use with ADW and ATP -…
-
GA ANNOUNCEMENT - Changes To Access Methods for Files In S3 And Azure Blog StorageContent It is now possible to use a pre-signed URL in any DBMS_CLOUD procedure that takes a URL to access files in Amazon S3, without the need to create a credential. It…
-
GA ANNOUNCEMENT - APEX 20.2 Now Available In Autonomous Database-SharedContent The version of APEX within Autonomous Database has been upgraded to version 20.2. This release of APEX introduces several new features and enhancements to help d…
-
How can I setup and use loadjava utility without installing oracle database?Summary How can I setup and use loadjava utility without installing oracle database?Content Is there a way at all and if yes, then how to enable java code calling/execut…
-
Autonomous Data Guard Standby URL, IP Address, CertificateSummary Questions on what the Standby database looks like when using Autonomous Data GuardContent Hi I've been reading about Autonomous Data Guard and it looks like a ni…
-
ADB Email NotificationSummary Email notification needs to include tenancyContent I receive emails every time an ADB is created. It's good to see that the tenancy is now added to the new email…
-
Is the upgrade implemented onlineSummary Is the upgrade implemented onlineContent Hi guys, One general question: for autonomous databases, I understand that the upgrade is automatically performed but do…
-
ATP Object Deployments - Hub and Spoke configurationSummary Looking to have an ATP database (hub) control one or more other ATP or ADW databases (spokes) with regard to object deployments for things like views\MVs and pro…User_2025-02-08-03-47-01-847 15 views 2 comments 0 points Most recent by User_2025-02-08-03-47-01-847
-
Latest Universal Theme refresh - Login Page TemplateSummary Refreshed Universal theme and the login page template appears to have been modifiedContent Hello. I was prompted to refresh our Universal Theme this morning. We …
-
REGISTER - Make Machine Learning Work for You: Nov 18 9:00am -11:0am PTContent Tune in to learn how to harness #machinelearning and #transform your data into valuable #insights. We’ll highlight best practices and core use cases to help you …