Explore Oracle on Experts Exchange

Expert Solutions for Your Tech Problems

OracleOracle Database

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its prim...

Read more
  • 80K Content
  • 9.9K Contributors

Expert Spotlight
Software Developer

A person who never made a mistake never tried anything new.
- Albert Einstein

FORTIS FORTUNA ADIUVAT
SI VIS PACEM PARA BELLUM

Troubleshooting Solution

oracle security patches

byPau Lo
1
In a scenario where your company purchases an on-premise ERP system with underlying Oracle database, …
Troubleshooting Solution

Data Guard gap with primary MRP0 WAIT_FOR_LOG

bydbadm
3
Hi,
my Oracle version is 18c on Linux
I've following DataGuard configuration:

DGMGRL> show …
Troubleshooting Solution

How to update just the year part of a date field without impacting date and month in oracle?

3
How to update just the year part of a date field without impacting date and month in oracle?

It may …
Troubleshooting Solution

How to Find an ending space in a data stored in column for a field.

6
In Oracle, there is a number(like 2653) in a column that contains an ending Space character towards …
Troubleshooting Solution

SQL using XREF table

bydeleyd
1
I'm rusty on my SQL. I need a statement which is essentially:

and the XREF table is something like: …
Troubleshooting Solution

Equivalent in Oracle to SET NOCOUNT ON (T-SQL

byNuno
2
Hi,

SET NOCOUNT ON is a set statement which prevents the message which shows the number of rows …
Troubleshooting Solution

SQL Plan Baseline is not used

bydbadm
1
Hi,
My Oracle version is: Oracle Database 18c EE on Oracle Linux Server 7.9

I have seen various case …
Troubleshooting Solution

issue doing exdpd

9
hi am having this issue doing exdpd
expdp username/password@dbname/hostname schemas=username …
Troubleshooting Solution

How can I join two tables in an Oracle update statement

2
Need to update OPERATION_BOM.UNIT_PRICE with the values in PARTS_MASTER.LIST_PRICE joining by …
Troubleshooting Solution

Wrong Extended_Timestamp in xml audit file

byRaf
3
Hi,
I started using the Oracle Audit Trail in XML format (Oracle 11.2.0.4.0 EE on Windows):


But my …
Troubleshooting Solution

DBA unavailability BCP testing

byPau Lo
4
For business continuity testing purposes, specific to the DBA section of the IT support department …
Troubleshooting Solution

DBA documentation for cover scenarios

byPau Lo
1
Specific to the role of a DBA, for your typical working 'day to day' administration activities, plus …
Troubleshooting Solution

Connecting to oracle 19c through java application facing this issue java.sql.SQLException: Io exception: NL Exception

12
Hi Experts,
I am trying to connect oracle19c database through java application.
facing below error.

Troubleshooting Solution

Configuring Server to add new Oracle instances

byRaf
6
Hi experts,
I've an Oracle 19c RAC 2 Nodes with following current system information:

[root]# lscpu
Troubleshooting Solution

row-level locking in Oracle

byNuno
1
Hi,
On Sybase, we can force row-level locking for a table using this statement:
Is there an equivalent …
Troubleshooting Solution

sql openquery run time is really long

4
Hi experts,
i have this query that uses a linked server (from_ams) to connect to an oracle database. …
Troubleshooting Solution

ALTER AUDIT POLICY CIS_UNIFIED_AUDIT_POLICY ADD ACTIONS CREATE USER; results in ORA-46357: Audit policy CIS_UNIFIED_AUDIT_POLICY not found.

bytalahi
2
I received a list of items from a security scan that I need to implement.

Item: Ensure the 'CREATE …
Troubleshooting Solution

How can I be expert in collecting data with Oracle Fusion (OTBI)

1
Actually, I know the how to use the OTBI but my issue is that I am facing a lot of subject areas to …
Troubleshooting Solution

ORACLE SQL Loader issue with dates

3
I'm getting an error loading an ORACLE table from a CSV file with SQL Loader. This is the file being …

Do more with Experts Exchange.


Get Answers

Join a Group Discussion

Collaborate

Monitor your Site

Explore solutions and more