I have a table which contains a primary key column which is auto incremented from application. How can I modify the column to be an identity column in Oracle 12c? A sample case is provided below- ...

all I'm trying to connect to an Oracle 19C database. I have installed two Oracle Clients (11g and 12c) because we need to support legacy programs. I can connect with no issue with any user using sq...

I'm storing a java class A as A_DOC in a clob column in my database. The structure of A is like: { id : 123 var1: abc subvalues : [{ id: 1 value : a }, { id: 1 value :b } ... } ]} I...

I just installed Oracle database, and it was missing the SCOTT schema. So I am trying to generate it myself. I got the sql script of Scott schema, but when I try to run the query CREATE USER SCOTT ...

I am working on the project which used ORACLE 12c db as back-end. and My application is build in java 8. It was working fine since last few month. But suddenly client got an error SQL Error: 1741...

I am using data pump to perform an import on 4 .dmp files and keep on receiving the set of errors as below: ORA-39002: invalid operation ORA-39070: Unable to open the log file. ORA-29283: invalid...

How to install Oracle Instant Client Version 12.1.0.2 (64-bit) on a Mac (OS X 10.11.5) I have downloaded version 12.1.0.2 (64-bit) version and unzipped the file. I now have the following files un...

I am trying to run Oracle db in docker on M1 Mac. I have tried images from both store/oracle/database-enterprise:12.2.0.1-slim and container-registry.oracle.com/database/enterprise:12.2.0.1-slim bu...

I am trying to install Oracle 12c instant 32-bit client alongside my 64-bit installation because I can't connect Visual Studio to the 64-bit version (throws BadImageFormatException). I run the inst...

Is there equivalent to this T-SQL query in PL/SQL (Oracle 12c)? UPDATE A SET A.columnA = 10 WHERE A.columnB < 30 OUTPUT INSERTED.*, DELETED.* The query updates table A and at the same time ret...

It came to my attention that Oracle EXTRACT(XML) function is deprecated in Oracle 11g. I used to make my XML processing by following approach: DECLARE TYPE xmltype_table IS TABLE OF xmltype INDE...

I can't install Oracle Database, because I have error [INS-20802] Oracle Database Configuration Assistant failed My PC: Windows 10 Pro; Intel core I3; 100+ gb free space My logs: https://1drv...

Yesterday I installed Oracle 12c Enterprise edition on my laptop. When I tried to connect to DB via SQLPLUS i got the below error C:\Users\USER>sqlplus SQL*Plus: Release 12.1.0.2.0 Production ...

I am trying to connect my grails project to Oracle databse(Oracle 12c) in windows(8) system. However, whenever I run my application I get following exception : Caused by: org.apache.commons.dbcp.S...

I'm trying to migrate to Oracle.ManagedDataAcess from unmanaged version and receiving randoms ORA-12570 TNS:packet reader failure. I don't know why this error starts, but once it starts, every su...

I'd like to have returned to me (via cx_oracle in python) the value of the Identity that's created for a row that I'm inserting. I think I can figure out the python bit on my own, if someone could ...

I try to create an auto incremented column on a table and as I see in this post there are 2 ways, the second implementation with the Identity column is a more elegant solution, but when I try to im...

I work in an Oracle instance that has hundreds of schemas and multiple developers. We have a development instance where developers can integrate their work before test or production. We want to ha...

Background I need to fetch a few thousands rows from Oracle and convert them to JSON for use in SlickGrid. Currently I am fetching the rows in PHP, converting it from ISO to UTF-8 with iconv and ...

I am using the following in cmd. expdp system/*****@11.11.1.11:1521/orcl schemas=HR directory=DATADIR dumpfile=HR_20150625.dmp logfile=HR_20150625.log version=11.2 The database from which schem...

How do you check if a specific trigger is enabled or disabled in Oracle/SQL? The following specifies if my trigger is valid or not -- but not enabled or disabled SELECT * FROM ALL_OBJECTS WHERE O...

We have switched to new Microsoft ADFS server and now we have to use LDAPS (LDAP over SSL on port 636). However in PL/SQL packages by adding DBMS_LDAP.open_ssl (based on here ) I get : ORA-31202: ...

I have created a simple deterministic function , and I am calling it using a select query in a cursor as shown below CREATE TABLE TEMP (dt DATE); INSERT INTO TEMP SELECT SYSDATE FROM DUAL CONNECT...

So far, any table that has a column name longer than 30 characters gives an UNSUPPORTED Operation when querying V$LOGMNR_CONTENTS If I drop the column or adjust the size to be <=30 then all the ...

I have below string: ThisSentence.ShouldBe.SplitAfterLastPeriod.Sentence So I want to select Sentence since it is the string after the last period. How can I do this?