Database Tools
Discussion List
-
What are some good strategies for optimizing performance of object store based data/delta shares?Summary: Working on stress testing performance of the object store based data/delta shares (specifically using the provided LINE_ORDER sample data ~600 Billion records).… -
oracle autonomous database on free tier - account lockedSummary: Cannot access Database Actions on my OCI tenancy. Content (please ensure you mask any confidential information): I use an Oracle free tier Autonomous Database o…Robinson Lovatto-Oracle 19 views 6 comments 0 points Most recent by Keith Laker-Oracle Autonomous Database
-
Autonomous database upgrade 19c to 23aiSummary: Hi We have a set of ATP/ADW instances that are in 19c and should be upgraded to 23ai version. Please advise what are the options and things to consider/risks/is…
-
Can a consumed data share be subsequently shared out?For example: If I'm consuming a databricks datashare, that results in a external table/view in ADW, can I then configure that external table/view to be a part of a ADW d…
-
How to insert comma delimited values in one column using DBMS_CLOUD?Summary: Hi Team, We are trying to insert the bulk data using DBMS_CLOUD_COPY_DATA/DBMS_CLOUD.CREATE_EXTERNAL_TABLE. In source file, We have few columns like tags/additi…
-
DBMS_SHARE.CREATE_SHARE_LINK_VIEW failing with ora-20863Summary: I've set up a share link to a share provide that I've confirmed can be authenticated to by running: SELECT *FROM DBMS_SHARE.DISCOVER_AVAILABLE_TABLES(share_prov…
-
The clock time on my autonomous database is wrongSummary: The clock time on my autonomous database on OCI free in LONDON is 2 minute slow. I have a friend who has an instance in Cardiff data centre and if we issue the …
-
DPY-6000: Listener refused connectionSummary: Unable to connect to ATP DB via Python code DPY-6005: cannot connect to database (CONNECTION_ID=""). DPY-6000: Listener refused connection. (Similar to ORA-1250…Monish Munot-Oracle 82 views 1 comment 0 points Most recent by Keith Laker-Oracle Autonomous Database -
Modification/Manual Allocation of Default Consumer Group Concurrency and DOP in ADW?Summary: Is it possible to modify the default concurrency and DOP provided within the pre-set consumer groups in ADW? For example, if you do not need as much concurrency…
-
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 119 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 122 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 21 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…