Database Tools
Discussion List
-
My free database is always stopped since the trial period has expiredSummary: My free database is always Stopped since the trial period has expired. Content (please ensure you mask any confidential information): I doesn't use more than 20… -
You are attempting to use a feature that's not currently enabled for this tenancySummary: Hello, I have an ever free OCI account, now I have an virtual machine instances enable (Ubuntu) and now I was trying to create an ATP DBA for free but I receive… -
error in writing a dumpfile with expdp (autonomous cloud db). Can you check this please?error in writing a dumpfile with expdp (autonomous cloud db). Can you check this please? tenant: itbbcloud01 DBMS_METADATA.FETCH_XML_CLOB KUPW: In procedure SEND_MSG. Fa…
-
Golden Gate reconfiguration after source database RMAN cloneSummary: Customer is using Golden Gate (Cloud) to transfer data from on-prem Peoplesoft database to Oracle ADW. In DEV/UAT environments, the source Peoplesoft database w…Debadrita Ghosh-Oracle 14 views 1 comment 0 points Most recent by Keith Laker-Oracle Autonomous Database -
How to re-create tenancy in always-free subscriptionSummary: Hi, I have an always-free account on cloud.oracle.com. I wanted to have this account terminated and request a new one in Chicago region, but I was able to termi…
-
Role Assignment not working for ATP Custom UserHi Team, We provisioned a new ATP and using web console created new DB user and assigned unlimited quota, connect, resource and DWRole. We are able to connect from SQL d…
-
When will 23C be available on ATP?Summary: When will Oracle Database Version 23C be available on ATP?
-
Migrate on-premise database to ADBSummary: We have a requirement to migrate DB 19c on-premise to ADW. We have exported the dump on the source DB server but the size is 280 GB, so uploading to object stor…Debadrita Ghosh-Oracle 33 views 6 comments 0 points Most recent by Shanmugam Vellore Thyagarajan-Oracle Autonomous Database
-
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 …
-
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…
-
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 …Debadrita Ghosh-Oracle 43 views 1 comment 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
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… -
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…
-
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 …
-
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…
-
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…
-
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…
-
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…
-
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…
-
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…
-
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 …
-
Encountering an error of insufficient privileges when attempting to execute DBMS_CLOUD.COPY_DATASummary: I am encountering an error of insufficient privileges when attempting to execute DBMS_CLOUD.COPY_DATA in a PROCEDURE. Content (required): I'm working on creatin…