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
-
Data Transform: in the Create Data Flow Popup Window, the save button is disableSummary: I try to follow the livelab: Data Studio - Self-service tools for everyone using Oracle Autonomous Database In the Lab 7, Step 3. After I choose the connection … -
Account has reached maximum limit for Always Free Autonomous Database instancesSummary: Hi to all, we are not able to create an Autonomous Database even though we have only 1 ADW. The error we get is: "Account has reached maximum limit for Always F…
-
ORA-20000: No Oracle File System mounted (DATA_PUMP_DIR)Summary: We are facing the same issue with, p3consulting - https://community.oracle.com/customerconnect/discussion/722932/no-oracle-file-system-mounted for both our free…
-
Difference between provisioned, allocated and used storageSummary: We provisioned an ADW instance with 1 TB storage and imported some data. Now, the allocated storage = 626 GB, while used storage = 547 GB, which indicates that … -
ANNOUNCEMENT - FREE 1-DAY AI WORKSHOP FOR ARCHITECTS AND PRACTITIONERSSign up for our free 1-day workshop to learn more about Oracle's self-service modern data platform architecture. The Oracle Autonomous Database Product Management team i… -
No Oracle File System mountedSummary: Can't backup one of my free ATP database (21c) since today and when executing SELECT * FROM DBMS_CLOUD.LIST_FILES('DATA_PUMP_DIR'); I got the error: ERROR at li…
-
Connect MYSQL Database in APEXSummary: I have a requirement to connect with external MYSQL database and bring the data to Oracle Database Cloud. Content (please ensure you mask any confidential infor…
-
dbms_cloud.list_objects not returning data as other user than ADMINSummary: As ADMIN dbms_cloud.list_objects returns a list of objetcs; As other DB user with same credentials not returning data and not returning errors. Content (please …
-
SQL developer web with Multiple TabsSummary: When using SQL developer WEB upon a ADB, only one tab of SQL code is allowed; my organization needs possibility to have multiple tabs to launch queries in paral… -
MongoDB API access disable for Always Free Cloud?Summary: Can't re-enable MongoDB API in Oracle Cloud -> AD -> Autonomous Database details -> Tool configuration tab. It was working for more than year prior todays patch…
-
retrieving old version of code ( database package)Summary: how can I retrieve the old version of the code ( database package)? Content (required): I have compiled the wrong version of a database package and lost the rig… -
Trouble with Build Analytic Applications using APEX and Analytic Views Live LabSummary: Content (required): When trying to login as MOVIESTREAM user, I get this error. This is under Lab 3 Task 1 of the "Build Analytic Applications using APEX and An… -
Backup Retention blocking Clone?I have a single Apex database on the free tier (about a gig in size) and I'm trying to make a clone. Based on all the documentation I've read, I should be allowed two fr…
-
Storage limit allocated x storage used.Hello. I am a user of the Autonomous Database with APEX for just over 1 year in the Always Free layer, and I realized that the allocated storage increases significantly …
-
Unable to clone a databaseSummary: I'm working with an autonomous database (Apex type) in the Free Tier. I only have one database and I'm trying to clone to a new DB for testing. On the clone pag…
-
How to access DBMS_CLOUD package on Autonomous DB free tier?Summary: I'm on Always free Autonomous DB. The DB version is 19c. However I cannot find / use the DBMS_CLOUD package Content (required): The DBMS_CLOUD package seems mis…
-
Unable to stop or restart free tier ATP databaseI am unable to restart an ATP database. The work request has the following error message: The Autonomous Database operation failed due to an unknown error. Refer to JobI…
-
Cannot login to Autonomous JSON database - Login page doesn't allow to press submitSummary: When trying to login to my AJD on my "Always Free" account, I'm not able to sign in. I am trying to login to access "All Database Actions", but not successful. …
-
How to solve this error of Oracle apex- 1403-no data found - rest data sourceSummary: Hi Experts, we are trying to upload file into OCI Object storage from Apex, so we created web credentials, rest data source and pages for uploading file. when u…
-
Continuous Autonomous Database Stopping Issue (Always Free Tier)Hello Oracle community, I'm facing an issue with my Autonomous Database using the Always Free tier. The database keeps stopping continuously, and I'm unable to restart i…
-
Is there any way to leverage Oracle Fusion Workflow for transactions from oracle ATP+APEX?We want to use Oracle BPM in Fusion Application to implement approvals for transactions in our ATP DB and APEX. And found a documentation about 'Implement Approvals for …
-
ORA-01031: insufficient privileges when attempting to SFTP to OIC File serverSummary: Unable to FTP to OIC SFTP server from ATP Database Content (required): I am trying to connect to the OIC SFTP Server from ATP databse, something like below. But…
-
How export schema tables if DB has an APEX workload type?Summary: If DB has an APEX workload type datapump can't be used. Content (required): I read several documents about datapump that is the main way to export data from a s…
-
How can I prevent or further debug this ORA-00600?Summary: ORA-00600: internal error code, arguments: [cvwtynmBasic1], [cannot find datatype entry in internal table], [252], [], [], [], [], [], [], [], [], [] Content (r…
-
I can't find my database and apex applications anymore. How can I recover Cloud error?Summary: I search for my database in my tenant but I get an error from the cloud. Content (required): After login I try to click to open my database on cloud from cloud …
-
Cannot create Autonomous DB (ATP)Summary: I am trying to create a Autonomous DB as a part of the course. However, when I'm trying to create it, its not letting me create. The create button doesn't do an…
-
ADB Excel add-in : Error Add-in could not be started . Re-install does not work.Summary: Hi - From the Autonomous database tab in MS excel and then clicking on About or Connections givers an internal add-in error "Add-in could not be started" See at…
-
Query on data storage/performanceSummary: Due to excess data (5M records) causing performance issues and a heavy load on the application, we have decided to migrate the aged data to the Oracle database.…
-
Space Usage in container is too high on ATP DBSummary: Hi, I'm having an issue with my (Always Free) Autonomous Data (Transaction Processing workload type) where for some reason it thinks that it is full but I haven…
-
Is it possible to get Autonomous DB to automatically switch to Daylight Saving Time (such as BST)?Summary: Is it possible to get Autonomous DB to automatically switch to Daylight Saving Time (such as BST)? Content (required): Is it possible to get Autonomous DB to au…