Category 219-2
Discussion List
-
How to Connect Power BI Desktop to Oracle Fusion Cloud 24c FSCM databaseSummary: I would like to know the steps to Connect Power BI Desktop to Oracle Fusion Cloud 24c FSCM database. Content (please ensure you mask any confidential informatio…Swapna Rachamalla 7 views 1 comment 0 points Most recent by Shanmugam Vellore Thyagarajan-Oracle Database -
How to find amount of space used up in cloudSummary: For audit purposes need to find the size of data stored on oracle cloud SaaS Content (please ensure you mask any confidential information): Version (include the… -
migration to OCIHi Team, We have Oracle database 19.17, single node with 150GB size. We have to move this to OCI DBCS VM. We dont have direct connection from Onpremise datacenter to OCI…
-
How to solve this error of Oracle apex- 1403-no data found - rest data sourceSummary: Hi Experts, we are trying to upload file into OCI Object storage from Apex, so we created web credentials, rest data source and pages for uploading file. when u…
-
-
There is no spanish(EN) transulation in Table(FND_APPLICATION_TL)Hi Team, There is a column called error_warning_message from" FUSION_ORA_ESS.REQUEST_HISTORY" customer wants to convert the error warning message column to Spanish langu… -
Where binding variable of a Fusion page is saved ?Summary: Page path: My team --> show more --> Team time card --> enter to anyone time card This is the Time Card page there is a lot of binding variables i want know whi…
-
Please share sample code that takes Json array as in value and out value in to package procedureSummary: Looking for a sample code that takes Json array as IN parameter into the package using json_array_t Looking for a sample code that takes Json array as OUT param…
-
How To Login With SYS User As SYSDBA In Oracle Autonomy Database Using SQLDeveloperSummary: How To Login With SYS User As SYSDBA In Oracle Autonomy Database Using SQLDeveloper I Try To Log With Next Methods and It Refuses To Login Database Password Cre… -
How to create backup for Oracle SaaS InstancesSummary: I want to know: What is the minimum and maximum duration for which Oracle SaaS instance backup can be taken? If we can take backup of server outside oracle. Ste… -
How to create global variables like person number on a certain page in Oracle Fusion ?Summary: I want to create variable that holds person number on Time and Leaves page in Oracle Fusion how to do something like this
-
When will upgrade of existing Base Database Service databases to 23c become available?Summary: When will upgrade of existing Base Database Service databases to 23c become available? Content (please ensure you mask any confidential information): We have ex… -
PLS-00487: Invalid reference to variable 'INT'Summary: I am trying to execute the PL/SQL proc within Package but getting error while execution as schema name is 'INT' which is a reserved keyword. when I alter the se…
-
string literal longer than 32767 bytes.Summary: Hi Team I am trying to load JSON File content into DB table, but my block is throwing me an error as "string literal too long." set define off; DECLARE v_json_d…
-
Standby database creation while Migrating Primary Database using RMAN XTTS (Cross PlatformMigration)Summary: Is it feasible to concurrently build a standby database for the new target database while performing XTTS migration and activate Data Guard on OCI Content (requ…Subashini-Oracle 163 views 1 comment 1 point Most recent by Shanmugam Vellore Thyagarajan-Oracle Database
-
How do I set the time zone data file in Autonomous Database?Summary: Receiving ORA-30094 error when building OML Model on Autonomous Database Content (required): I am receiving a an error: ORA-30094: failed to find the time zone … -
Slow Database Upgrade from 11g to 19cSummary: We recently attempted to upgrade a copy of our Production database from 11g to 19c in preparation of actual Production upgrade to be done in few weeks. The Upgr…
-
DB 19c upgrade and java programs in DBSummary: DB 19c upgrade caused disappearance of java programs from DB Content (required): We recently upgraded an on-prem Oracle 12.1.0.2 DB to 19C (Non RAC). It was fou… -
How to reclaim space in .dbf file?Summary: After purging or cleanup activities, how to reclaim space in .dbf file at OS end? Content (required): At the time of cleanup activities we dropped 500 GB space …Bapiraju Swamy Vuda-Oracle 233 views 21 comments 1 point Most recent by Himanshu Nayak-Oracle Database -
MDS NEWS: 19c Adoption WorkshopsOracle Advanced Customer Services (ACS) continues the series of Database 19c Adoption Workshops. These live webinars are available to Market-Driven Support customers at … -
How to Factory reset ubuntu instance, like fresh installationSummary: Hello, Actually I want to reset my Ubuntu instance, It's having problem with MySQL, I tried a lot but couldn't able to solve it. Hence decided to set my instanc…
-
Reduce minimum storage for DB on VMIs it possible to request a smaller DB than the options you get when provisioning a Standard Edition v21.8 on a VM: Shape: VM.Standard.E4.Flex CPU core count: 1 The mini… -
503 Service Unavailable - OCI APEXHi, I'm having the following problem with the OCI when trying to run APEX from it. I have the always free version. I would appreciate any help.Christian Osvaldo González 92 views 5 comments 0 points Most recent by Christian Osvaldo González Database -
Upgrading Free Tier account to Paid account - how long does this take?Summary: Upgrading Free Tier account to Paid account - how long does this take ? Content (required): I have had the free tier account, the trial period has expired and I…
-
Unable to grant role as SYSDBA to system user from dropdown option in SQL Dev.Summary: Content (required): Hi team, I am unable to grant role as SYSDBA to the system user having been granted as DBA role from the SQL query. But when I am trying to …
-
Before I upgrade to PAYG, why are my ADW costs so low?Summary: I'm going to switch to PAYG to take better advantage of WebLogic stacks but need to understand why my ADW costs are far less than shown in the pricing calculato… -
Creating Tablespaces in PDB of OCI DB SystemHi everyone I would like to thank Sinan Petrus Toma for his blog post It could be used for managing the CDB of the OCI DB System and creating Tablespaces in CDB Is there… -
Scale mysql databaseSummary: Scale mysql database Content (required): Hello, I just created a Mysql Database. I'd like to scale it in CPU/Memory. From the documentation, I just need to edit…
-
How to remove duplicate tags from XMLSummary: I am facing some issue while using UTL_HTTP rest service package we are getting some duplicate tags in client xml file which is causing issue to do sql Error : …