Stack Overflow
Stack Overflow

Questions tagged [oracle12.2]

16 questions
2
votes
1 answer

Individuals in multiple departments affecting grand total count

I have a report I am trying to simplify but I am running into an issue. (Undesired) The rows/columns of the report currently look like the following. Department Total Probation (%) Suspended (%) All Employees 32 16.3 1.4 All…
XmalevolentX
  • 121
  • 1
  • 2
  • 9
1
vote
0 answers

Oracle stored procedure ORA-00972: identifier is too long

I've imported some customer DB using Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production. Now I need to create a procedure with identifier length > 30 but this is failing with the following error : "ORA-00972: identifier is…
kruxy_
  • 11
  • 1
0
votes
1 answer

Move BLOB from a table to another without copy data

I'm restructuring a table in our database, moving a BLOB column from one table to another. This table has 300GB of BLOB data. The database server has disk space limitations, so there is not enough space for a copy of the data during migration. Is…
marciel.deg
  • 400
  • 3
  • 17
0
votes
2 answers

Is there an Oracle built in function that converts XML to JSON where the XML format varies?

Using Oracle 12.2 Goal: Convert XML data in a CLOB to JSON Desire: Use built in functionality of Oracle (does it even exist?) I'm under the impression that Oracle CAN convert the XML to JSON on it's own. However, I am unable to find a straight…
edjm
  • 4,830
  • 7
  • 36
  • 65
0
votes
1 answer

Database connection test failed in web-logic server

I am getting below error while creating data-source to a database in weblogic server 12. Error Cannot load driver: com.microsoft.sqlserver.jdbc.SQLServerDriver
trz
  • 9
  • 3
0
votes
0 answers

due to foreign key relations, oracle locks a table which will not be affected by the delete statement (on delete set null / on delete cascade)

We observed that while issuing a delete statement, oracle is locking tables which are not impacted due to the specific delete statement. Consider 4 tables as below. create table TABLE_A (id number(14,0) not null primary key, code…
GGC
  • 1
  • 2
0
votes
0 answers

After oracle client upgrade from v11 to v12 getting System.InvalidOperationException: Operation is not valid due to the current state of the object

After I upgraded oracle client version 11 to 12.2, asp.net application start to give: System.InvalidOperationException: Operation is not valid due to the current state of the object. at Oracle.DataAccess.Client.OracleTransaction.Commit() Nothing…
kartal şahin
  • 9
  • 4
0
votes
1 answer

Get trace results without having access to filesystem (Oracle 12.2)

I need to do some profiling inside a stored procedure hooked up to a fast refresh on commit materialized view. Trace is the only way to get the detail I need. I have all the permissions I need except for access to the filesystem. To access the…
Monolithguy
  • 313
  • 6
  • 17
0
votes
0 answers

Oracle 12 - How to identify duplicates with increment?

I want to differentiate duplicate values in my query by adding an increment or a count of some sort. The idea is to concatenate my two columns to create a new unique reference. I tried this : SELECT value, COUNT(*) OVER (PARTITION BY…
Turfern
  • 1
  • 1
0
votes
1 answer

Error while installing JDeveloper 12c 12.2.1.4

I want to install Oracle JDeveloper 12c (12.2.1.4.0) Studio Edition. But I am facing some problem. I can't install the software. I have tried the Generic Version, windows 64bit as well as 32bit. But all the time same issue. But when I install the…
Mohammad Rahat Akand
  • 1
  • 2
0
votes
1 answer

Kronos SQL Query-ORA-00923: FROM keyword not found where expected

So I'm trying to query Kronos production and I'm coming against the error ORA-00923: "FROM keyword not found where expected ". I've read similar posts and as you can see below, the keyword FROM is the last selected item in the statement. SELECT …
HSB
  • 19
  • 5
0
votes
1 answer

weblogic does not find .ear in stage, but it is there on the file system

When starting the weblogic server I get this error: Caused By: java.io.IOException: /home/weblogic/Oracle/Middleware/user_projects/domains/mydomain/servers/managed1/stage/myear/myear.ear (No such file or directory) with :…
user1919452
  • 21
  • 7
0
votes
1 answer

Oracle Trigger Issue : SQL Statement ignored, ORA-00942: table or view does not exist

While creating below trigger i am getting this error. Trigger script - CREATE OR REPLACE TRIGGER myuser.tt_tab BEFORE DELETE ON dbo.tab REFERENCING OLD AS old NEW AS new FOR EACH ROW DECLARE err_code …
Koushik Roy
  • 6,868
  • 2
  • 12
  • 33
0
votes
0 answers

Not able to run oracle database 12 on kubernetes with persistent volume

Hi I am trying to run oracle db 12 on k8s, with a persistent volume, but it's throwing the error below. please what I am missing I have created a pv/pvc, mount path /opt/oracle/oradata permissions to uid 54321 are provided Listener Log File …
ar zi
  • 1
  • 2
0
votes
1 answer

Oracle CONTAINS issue

so I'm stumped here. I'm using Oracle 12.2. Say I have 2 records in table "t" where the SEARCH_NAME column is indexed by type CONTEXT: SEARCH_NAME ----------------- REED, JAMES D REED, JAMES J I want to search for the first record (REED, JAMES D)…
Jason Smith
  • 1
  • 1
1
2