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.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 … -
ORA-01035: ORACLE only available to users with RESTRICTED SESSION privilegeSummary Trying to access my ADW today but getting ORA-01035 when trying to connect as any user other than ADMINContent Hi, I hope you can help. When I try and log into m… -
cloning a database is failing at 18%Summary Trying to create a autonomous database clone and is constantly stuck at 18% and then fails.Content I'm trying to create a clone of my autonomous database (via da…
-
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… -
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… -
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…
-
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…
-
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…
-
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 …
-
ATP auto indexing consumes more than 16GB in SYSAUXDear valued Oracle DBA community, after enabling Oracle Autonomous auto indexing feature some months ago for testing purposes, I recently realized that since this time S…
-
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…
-
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…
-
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. …
-
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…
-
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…
-
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…
-
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 do I get around the ORA-30094 error in Autonomous Database?Summary: Receiving ORA-30094 error when building OML Model on Autonomous Database Content (required): Trying to begin using OML4SQL but when following the example below,… -
Cannot create Data Share on Autonomous Data WarehouseSummary: I am trying to create a Data Share in ADW but when I try to select the Cloud Location the dropdown list button does not work. I tried creating different Cloud S…
-
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 …
-
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…
-
ADB Excel add-in : Installer issueSummary: I am facing issues with installing the Autonomous Database Excel add-in on my Windows machine. As you can see in the attached screenshot, the install.cmd when r…
-
ADB URL for Oracle Autonomous Database Excel add-inSummary: Please can someone provide steps on how to get the specific ADB URL from the admin console. A video of the entire connection setup process with an example would…
-
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.…
-
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…
-
Unable to write file on OCI bucket with Header row from DBMS_CLOUD.EXPORT_DATASummary: Hi, I am writing a file from ATP (table) to the bucket in the OCI object storage it's working fine but the header row is not inserted. Please help to export the…
-
Getting Create session priveledge error through sql developerSummary: Getting Create session priveledge error through SQL developer Content (required): Hi All, I have Provisioned an ATP db. instance and when i tried to connect to …