Database Tools
Discussion List
-
When is APEX 24.2 getting released for Oracle Cloud ATB Database.24.2 has the Bug Patch for 37117164 Can anyone say when it's getting released
-
Create DB LINK between ADW and ATP DBSummary: Hello Experts, For our use case, we need the data stored in ATP DB to be available in ADW DB for another team. For this we are planning to use the DB LINK conce…
-
Hi, I am facing issue with oracle live labs OCI loginSummary: Hi, I am facing issue while logging into OCI console. I have used oracle live labs Run on Live Sandbox option to use OCI. I have used the username and password …
-
DPY-6005: cannot connect to database (CONNECTION_ID=qkBuaD1Uq1JopfePKo/5rA==) pythonanywhere.com ATPPython connectivity with ATP DB is working fine on local machine using the below code import oracledb Define connection detailsconnection = oracledb.connect( user="admin…
-
How we can convert big data file into single vector chunkIs there any way to convert complete CLOB data into single vector chunk. if yes which function we can use to convert. Currently i am using TO_VECTOR(VECTOR_EMBEDDING(doc…
-
autonomous database stopped not getting startedThe Autonomous Database operation failed due to an unknown error.Refer to JobId 4e38655a-a43d-473b-be51-8fbc8ce0ad4d and WorkRequestId a6a903e7-ff6e-442a-983f-5891873139…
-
How we can query to dba_object table in ATP?Hello. Is there any way to query dba_objects, dba_sources, dba_tables table in ATP dabase?. According we check with the ADMIN user we don't have granto query this tables…
-
dbms_cloud.copy_data Issue : ORA-20000: ORA-29283: invalid file operation: nonexistent file or pathWe are calling the dbms_cloud.copy_data procedure to download the file data in ATP db. It was working fine until couple of days back.Suddenly it has started throwing bel…
-
Uncommited Multipart Uploads - Storage BucketHi Team, We have uploaded files from onpremise linux server to OCI object storage bucket using below commands. sample :. oci os object bulk-upload --namespace-name axqui…
-
Is there an up-to-date Product Roadmap available for ADB/ADW?Summary: My organization would like to understand the product/feature roadmap for Autonomous Database, in particular the ADW flavor of it. I've looked but couldn't find …
-
not able to set ai profile using EXEC DBMS_CLOUD_AI.SET_PROFILESummary: Created an AI profile using command DBMS_CLOUD_AI.CREATE_PROFILE and set with command EXEC DBMS_CLOUD_AI.SET_PROFILE But, after running above scripts, when vali…
-
How Do I Access Files Created In Autonomous Database DATA_PUMP_DIR DirectorySummary: My OCI account is using an Autonomous Database and it came with an Oracle directory object called 'DATA_PUMP_DIR' which points to a specific file system directo…
-
Why are my newly created 23ai databases going straight from "Provisioning" to "Unavailable" ?Summary: I can't migrate my 21c DB to 23ai simply because I can't create and start a 23ai DB. Content (please ensure you mask any confidential information): I'm trying t…
-
Loading database via live feed not loading alphanumeric data on Autonomous DBSummary: When loading data via Autonomous DB the data load does not load entries that are alphanumeric even though data type is set to VarChar2 Content (please ensure yo…
-
PLS-00904: insufficient privileges to access object PUBLIC.DBMS_CLOUDHello, I have compiled a DB package with the admin user and I get a privilege error. I have modified the package and it gives me error, and it was working fine before. T…Iker Garcia Martin 25 views 4 comments 0 points Most recent by Iker Garcia Martin Autonomous Database
-
It is possible recover / restore from last backup AlwaysFree 21c databaseSummary: Hello everyone, I know, OCI has informed that the AlwaysFree 21c databases will be removed. But TBH, I have found in my mailbox just one e-mail about it. But ok…
-
how to connect to oracle Cloud 24c FSCM database from ExcelSummary: I would like to know the steps to connect to oracle Cloud 24c FSCM database from Excel. Content (please ensure you mask any confidential information): Version (…
-
Unable to copy JSON data from OCI Object storage to DB tableSummary: I have a JSON payload in OCI Object Storage and is available through public URL.I am trying to copy this data to an existing table TEST_TABLE_MAIN Question1) Th…
-
How to create a read-only user in an ATP databaseSummary: Our customers request to create read-only users in the ATP databases they have, basically they want to have a user who can only inquiry tables and check databas…Humberto Martín-Oracle 47 views 1 comment 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
Need to call DBMS_CLOUD but EXECUTE grant was removedSummary: One of our customers has two ATP instances with DBMS_CLOUD, they have several PL/SQL packages where they call DBMS_CLOUD without issues until last week where in…Humberto Martín-Oracle 10 views 2 comments 0 points Most recent by Humberto Martín-Oracle Autonomous Database
-
A quick recap of ADB announcements at CloudWorld Las VegasA quick recap of ADB+GenAI announcements from CloudWorld Las VegasA couple of weeks ago we held our annual customer conference in Las Vegas. During the event, there were…
-
My Oracle Free Tier-database-instance has disappeared.Summary: Last connections might be 2 weeks ago, but certainly not 90 days. Why did it disappear and, more important, how can I recover the instance? Content (please ensu…
-
The extended JSON data type REGULAR_EXPRESSION is not supportedSummary: I have an application that uses the MongoDB API for Autonomous JSON Database. I was attempting to do a case-insensitive find query on a collection using regex b…
-
How to replace new line character in one of the value in CSV during DBMS_CLOUD.COPY_DATA call?Summary: This DBMS_CLOUD.COPY_DATA API is failing during importing data from Object storage to ATP that is having a new line characters in one if its value. We are tryin…
-
Include the start_date and end_date OFS properties in the Oracle Autonomous DatabaseIs it possible to include the start_date and end_date OFS properties in the Oracle Autonomous Database configuration ? If not, how can I get this information?Jonathan Ivani-Oracle 21 views 0 comments 0 points Started by Jonathan Ivani-Oracle Autonomous Database
-
ATP in Private subnet, how to access database action (sql developer web) and Apex over internetSummary: Hi Team, We have an ATP provisioned in private subnet, how can we access the APEX and Database Action over internet, any pointer to that would be helpful? Thank…
-
Database link between ADW and on-prem Oracle DatabaseSummary: Database link between ADW and on-prem Oracle Database How to configure dblink on ADW to on-prem Oracle Database? Networking is ok, path analyzer return view val…
-
IP address of public ADWSummary: Hi, We wish to connect to a compute instance (ODI MP) from ADW via Apex. For this ADW, network type is set to 'Allow secure access from anywhere', so there's no…Debadrita Ghosh-Oracle 21 views 1 comment 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
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…
-
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…