To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Database
Discussion List
-
How to identify invalid date values in a varchar columnSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
support database monitoringSummary: Hello, IS Oracle Cloud support database monitoring (Provide DB monitoring solutions that is supported by the system for integration)? Content (please ensure you…
-
How can I change a VM.Standard1.1 Standard Edition VMDB to a more modern shape (e.g. AMD Flex)Summary: How can I change a VM.Standard1.1 Standard Edition VMDB to a more modern shape (e.g. AMD Flex) Content (required): I would like to change the shape of an existi…
-
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…
-
can one grant references to role?In our environment all developers accounts have the role 'Developer', this role has all the necessary permissions to do what they need to do bar one which seems crazy. I…
-
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…
-
rman active duplicate miscalculates sessions & processes parameters to start the auxiliary instanceSummary: When I start "dbaascli database duplicate" to create a duplicate database from a Snapshot Standby database rman active duplicate is miscalculating sessions and …
-
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…
-
Oracle Certifications for Beginner VBCS Developers using pl/sql , apexBeginner level oracle certifications for VBCS Developers using pl/sql , apex for career growth.
-
import dmp that has been exported from AR8MSWIN1256 into utf8hi, i have a problem, i have a .dmp file exported from oracle database that uses charset AR8MSWIN1256 and i have a new server with oracle database that uses charset utf8…
-
Rman Backup is too slowSummary: Full database rman backup is too slow in windows machine. How to find out the bottleneck ? Content (required): run{ ALLOCATE CHANNEL d1 DEVICE TYPE DISK; ALLOCA…
-
Datapump Export of DDL is extremely slow on On-PREMSummary: Datapump Export of DDL is extremely slow on On-PREM Content (required): Source Database size : 4.5 TB Platform: AIX DB Version : 12.2.0.4 For Migration purpose,…
-
How to remote cloning pdb method between on-premise to cloudSummary How to remote cloning pdb method between on-premise to cloudContent As per my knowledge we are not able to ping from cloud database from on premise http://docs.o…
-
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
-
How to secure ATP (DB Layer) in terms of IP Whitelisting but allow access to APEX App (Web Layer)Summary: How to secure ATP DB in terms of IP Whitelisting but allow access to Web Apps layer i.e. ORDS, APEX Content (please ensure you mask any confidential information…
-
How to connect Oracle Cloud ATP/ADW database from jasper report version installed with in the OCI VMSummary: Content (required): Connection With OCI ATP/ADW From With In the OCI VM instance using jasper report server Version (include the version you are using, if appli…
-
oracle data version managementhello, i'm wondering is there a way to manage oracle database data, In a way to view, how the data looked t time ago? ex: i want to view the data as if we are a month or…
-
Can you recommend a free to enroll rdbms 19c (or higher) courseSummary: for one of our DBA's who is still working on 11g we need a 19c course He needs: ASM RAC and admin Content (required): on premise - rdbms Version (include the ve…
-
""The proxy could not connect to the destination in time." ORDS Page errorHI Team, While accessing ORDS URL , I am getting below error. I am getting same for using self-signed certificate and Certificate Authority (CA) certificates too. Apex a…
-
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…
-
How to get the endpoint URL for ORDS API for table with SQL querySummary: Hi Experts How to get the endpoint URL for ORDS API for table with SQL query? Is this possible or we have to goto everytime OCI console. Please help. Content (p…
-
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…
-
Essbase error 1020098总结: 内容(必填):Essbase 错误1020098 版本(包括您正在使用的版本,如果适用):Oracle Fusion Financials Common Module Cloud ServiceEssbase 错误1020098 代码片段(添加支…
-
Autonomous database restart hangs on OCIHangs up 3 hours and more. What to do ?
-
Is database 23c going to available as Standard Edition?Summary: Is database 23c going to available as Standard Edition? Content (required): I have installed 23c DBaaS in our development environment, but noticed that there is…
-
How to get the logged user now in Oracle Fusion ?Summary: Is there any REST API to get the user that is logged in right now in Oracle Fusion
-
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…
-
get java error on installing rman OSBWS ModulOracle Secure Backup Web Service Install Tool, build 12.2.0.1.0DBBKPCSBP_2018-06-12 i tried to install the OSBWS Modul with oracle user on Linux 4.18.0-372.41.1.el8_6.x8…User_2025-03-28-20-47-36-517 91 views 1 comment 0 points Most recent by User_2025-03-28-20-47-36-517
-
OTM Migration path from AWS to OCISummary: OTM Migration path from AWS to OCI Content (required): Looking for OTM 6.5.1 Migration path from AWS to OCI Version (include the version you are using, if appli…