Category 219-2
Discussion List
-
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… -
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… -
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…
-
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…
-
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…
-
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…
-
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 11 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 211 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 91 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 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…Mohamed Younis ElShamy 1.1K views 2 comments 0 points Most recent by Mohamed Younis ElShamy Database -
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 : …