Application Development
Discussion List
-
Unable to write file on OCI bucket with Header row from DBMS_CLOUD.EXPORT_DATASummary: Hi, I am writing a file from ATP (table) to the bucket in the OCI object storage it's working fine but the header row is not inserted. Please help to export the… -
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 … -
Authorization failed while exporting to Object storage from ATPSummary: Hi I am getting authorize failed error while exporting data from ATP to bucket using dbsm_cloud.export_data package. ORA-20401: Authorization failed for URI - h…
-
Autonomous database is automatically stoppingSummary: Oracle autonomous database automatically stops with no apparent reason - it was not commanded to stop Content (required): Today I saw Oracle cloud database auto…
-
Is it possible to use Oracle Database API for MongoDB to run rocket.chat?Summary: I am trying to connect RocketChat with Oracle-DB, but get error "MongoServerError: Invalid index specification: text index only support on wildcard" Content (re…
-
Hi I am facing issue while passing rec array as input parameter in ORDS exposed package procedureSummary: I am facing an issue and not sure about doing it correctly I created a package and created a record type and CREATE OR REPLACE PACKAGE my_test_package AS TYPE t…
-
Failing when trying to create an Always Free Autonomous DatabaseSummary: I have logged into my OCI dashboard. I select to create an Autonomous Database. It fails. Content (required): Login to OCI Console From the menu, select Oracle …
-
Compilation error using PL/SQL Object Storage API in a program unitSummary: Setup: We are using an OCI ATP database and running APEX 22.2.1. The database user that owns the application objects has been granted the DWROLE. I can referenc…
-
python-oracledb thin client returns DPY-6005Summary: Connection to ATP 21c and ADP 19c (free tier, both TLS enabled) using Python thin client fails with DPY-6005! Content: I'm trying to connect to a 21c ATP and 19…
-
Cannot create table clusters on ADB shared infrastructureSummary: Cannot create table clusters on ADB shared infrastructure Content (required): Is it intended that u cannot assign tables to clusters on adb? Instead Oracle is c…
-
Cannot access Database Actions at Marseille RegionSummary: I get an error message when I press the "Database Actions" button The error message is: "Launch DB actions Failed to auto sign-in. Close this dialog and log-in …
-
Why does my database always free keep stopping every timeI was have new account on OCI, after my Free Tier accounts finished IN the database stop automatically ,and when I start it it's stop within 1 Minute again, and I can't …
-
Launch APEX button results in 400 Bad Request Error on newly provisioned Autonomous DatabaseSummary: Can't launch APEX on a newly created Autonomous Database on OCI Free Tier. Content (required): I am following the tutorial here: https://docs.oracle.com/en/lear…User_2025-02-12-22-05-31-355 912 views 4 comments 0 points Most recent by User_2025-02-12-22-05-31-355 Autonomous Database -
Why do my ATP instances sometimes go from "provisioning" to "unavailable"?Summary: We've been using the OCI DatabaseClient Python API to call create_autonomous_database. This works very well, but occasionally a newly created ATP's lifecycle_st…
-
Hi I am facing issue while fetching ORDS records limit more than 1000Summary: Hi , I am trying to fetch all tables records from ATP database using ORDS service but I am only getting 1000 records after setting ?limit=1001&offset=25 when I …
-
Can an APEX page generate a URL link?Content Hi team, I just want to know, can an APEX page generate a URL link so that an external application can redirect to that particular APEX page? So there is this mi…
-
ATP Object Deployments - Hub and Spoke configurationSummary Looking to have an ATP database (hub) control one or more other ATP or ADW databases (spokes) with regard to object deployments for things like views\MVs and pro…User_2025-02-08-03-47-01-847 15 views 2 comments 0 points Most recent by User_2025-02-08-03-47-01-847 Autonomous Database
-
SSB userSummary star schemaContent hi all Oracle autonomous has a SSB schema , its an example of star schemas , but the oracle schema is locked. From our admin user it is not po… -
oracle python to autonomous databaseSummary python cx_oracle airflowContent hi all we want to connect our apache airflow to the autonomous database in order to download some tables to hive/hadoop and i wan…