Category 245
Discussion List
-
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 23 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…
-
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…
-
I keep getting an error to upgrade. Is there a fix for itSummary: I was on a free trial period, and I want to upgrade, but when attempting to upgrade it tells me that it fails due to the below: I have checked the address of my…
-
can administrative user accounts be alteredSummary: I'm advising our internal Audit team about activities in ATP. They see administrative accounts like SYS and ADMIN. I'm trying to find documentation that states …Aaron Baker - Hanger, Inc 32 views 4 comments 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
Using Apex with ATP for Building Web AppHi Team, We are assessing Oracle Apex(comes with ATP DB) as a platform to build Web App/extension to Oracle Cloud ERP. There would be around 10 extensions to be built an…
-
AutoREST POST End-point loses all dataSummary: When using AutoREST on 23C for a specific table, if I POST to it, it loses all data that is sent along with it. This is only for this specific table, but anothe…
-
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…
-
Oracle APEX 503 service unavailableSummary: Service Unavailable HTTP Status Code: 503 Request ID: 0ee5370a491db4c7f7674c355fbd8502 Request Timestamp: 2024-01-12T13:59:18.785698Z The connection pool named:…
-
Unable to import APEX Application including backup filesSummary: I have a newly created OCI account for our school and I cannot import an APEX application from a different workspace. Content (please ensure you mask any confid…
-
When will 23C be available on ATP?Summary: When will Oracle Database Version 23C be available on ATP?
-
Create DBLINK from ATP to onprem on port different than 1522Hello, I tried to create a dblink from an ATP instance to a onprem db, and it works fine (mTLS) on port 1522. However if I try to change the port (eg: 6666) the connecti…
-
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…
-
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 32 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 …
-
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…
-
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 42 views 1 comment 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
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…
-
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…
-
ANNOUNCEMENT - ORACLE-MANAGED CONNECTIVITY TO SERVICENOWOVERVIEW Autonomous Database support for Oracle-managed heterogeneous connectivity makes it easy to create database links to non-Oracle databases. When you use database …
-
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 …Stéphane Lamy-Bouchard 22 views 4 comments 0 points Most recent by Stéphane Lamy-Bouchard Autonomous Database
-
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 …