Category 245
Discussion List
-
How to Migrate Autonomous Database with Workload type: APEXSummary: I am following This does not work for Autonomous Database with Workload type: APEX As Oracle Doesn't allow external connection Content (please ensure you mask a…
-
Apex not working after update, invalid packagesSummary: Apex is not working after its update . I cant even see Apex instance, i can use database. I see 2 invalid packages bodies APEX_240100.WWV_FLOW_CGI APEX_240100.W…
-
AI Assistant button not visibleHi, I have upgraded to APEX 24.1 on OCI. I cannot see the button AI Assistant in the SQL code editor. The bottom page of APEX shows relase 24.1 is installed :
-
How to rollback a tableHi, I am on always free offer on OCI. I have made a big mistake I have deleted records from a table. is it possible to rollback the table 24 hours ago ? Best regards. Ch…Christian Pitet 2 32 views 11 comments 0 points Most recent by Christian Pitet 2 Autonomous Database
-
how to send email from data transform service in ADBSummary: Data Transform Service in ADB allows to create dataflow, group dataflow to create workflow then schedule workflow to run specific schedule. But it does not have…
-
Unable to log inHi, I am using Alwaye free OCI Database and APEX. I am developing software under APEX on the platform, every day. I received this mail that "Your inactive Always Free Or…Christian Pitet 2 52 views 10 comments 0 points Most recent by Christian Pitet 2 Autonomous Database
-
Update for Autonomous Database Severless for July, 2024We are continually adding new features and enhancements to Autonomous Database, and here are the latest updates along with information about the most recent sales wins: …
-
Security of a stored procedure enabled as a REST service in Oracle Autonomous DatabaseHello, I created a stored procedure on Oracle Autonomous Database and marked it as REST enabled. When I do not require authentication, the service works correctly, but w…
-
A Drive like One Drive ?Hi, I would like to know if there is a system to store data on the OCI for free accounts ? We would like to secure our data there. Best regards.
-
invalid credentials.I am using Always Free AD on the free OCI. I have installed Oracle. But when I try to connect to APEX on the cloud, I get an error message "invalid credentials." How to …Christian Pitet 2 11 views 13 comments 0 points Most recent by Christian Pitet 2 Autonomous Database
-
English language on Interactive reports options instead of frenchHi, I am using APEX 24.1 on OCI. The interactive Report button is "Actions" and the Actions are in english. And the systems messages "Row updated" for example, are in En…Christian Pitet 2 21 views 12 comments 0 points Most recent by Christian Pitet 2 Autonomous Database
-
ORA-12530, TNS:listener: rate limit reachedSummary: How do I trouble shoot this error ? Content (please ensure you mask any confidential information): I observe this error in following configuration Automomous da…
-
Getting ORA-43912 whilst trying to create a page as a copy on Apex using 23aiSummary: I've created a new 23ai Apex instance and imported three applications from an Apex instance running on 21c. When trying to copy a page between two of these appl…Martin Bocutt-Oracle 45 views 1 comment 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
Account has reached maximum limit for Always Free Autonomous Database instancesSummary: I terminated one of my two Free Autonomous DBs earlier today to make room for 23ai. I only see one DB in my list of Autonomous Databases. Despite that, when I a…
-
How to Call Oracle Data Integration (MarketPlace) Scenario from ADWSummary: Hi All, we have Oracle Data Integrator Market Place in Public Subnet and ADW provisioned in same Tenancy. Can someone please let us know the steps to Call ODI S…Sunil Gunturu-Oracle 1 view 1 comment 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
May's latest new feature announcements for Autonomous DatabaseSummary: As May comes to a close, here is information about the new features released during the last 2 weeks along with some customer success stories. Don't forget to s…
-
My application login attempt return 503 error - Service UnavailableSummary: Unable to login into application, error 503 service unavailable Content (please ensure you mask any confidential information): When I look in dashboard, db is n…
-
APEX REST BASED LOV Don't show all valuesSummary: APEX REST BASED LOV Don't show all values Content (please ensure you mask any confidential information): Hi, I have created a Rest Data Source Based LOV and it …
-
How to connect ADB via command line in Mac OSSummary: How to connect ADB via commandline in Mac OS Content (please ensure you mask any confidential information): I am trying to connect to ADB from Mac OS Command li…
-
Advantage of ORDS service call in vbcs and cons of OIC call in vbcsHi experts advantage of ORDS api over OIC calls in vbcs . suppose ORDS being called in OIC for VBCS services what is the disadvantage its better approach or not? what is…
-
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…
-
ORA-65114 / Usage in container is too high / Problem: Cannot shrink Data Tablespace !Hi, The current situation on my Always Free tenant/Autonomous Transaction Processing DB: jofodb/jofodb1: SQL> select round(sum(bytes/1024/1024/1024),2) Size_gb from dba_…
-
APEX Report with SQL using WITH clause function gives error.Summary: Below query works fine in APEX SQL Workshop, but gives error (ORA-32034: unsupported use of WITH clause) when creating an APEX Interactive report. with FUNCTION…
-
Troubleshooting DBMS_CLOUD access to object storageSummary: I tried to access the object storage from ADB (free tier) but failed with "ORA-20401: Authorization failed for URI". Is access to object storage supported in fr…
-
ATP Private Endpoint - 502 Bad GatewayHi, Looking for advice on how to troubleshoot further our ADB, which we aren't able to access via our private endpoint URL anymore. Our setup follows this guide, with pr…
-
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 11 views 1 comment 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
Why occurs this error "ORA-01841: (full) year must be between -4713 and 9999, and not be 0"?Summary: When I try to do a SQL with a parameter date occurs this error "ORA-01841: (full) year must be between -4713 and 9999, and not be 0" SQL: select * from GL_DAILY…Franklin_Cardozo-Oracle 21 views 1 comment 0 points Most recent by Debadrita Ghosh-Oracle Autonomous Database
-
Insert / Update records in ATP database from CSV File with 1-2 million recordsSummary: Content (please ensure you mask any confidential information): We have scenario as per below : 1) Customer will provide the datafile by using upload button in U…