Stack Overflow
Stack Overflow

Questions tagged [oracle12c]

Oracle is an RDBMS product. Specific releases of the product are known as Oracle9i, Oracle10g, Oracle 11g and Oracle 12c. Generally there are two releases within each major version. Questions tagged **oracle12c** are assumed to be specific to this version or features introduced in this version.

Oracle is an RDBMS product from Oracle Corporation. Specific releases of the product are known as Oracle9i, Oracle10g, Oracle 11g and Oracle 12c. Generally there are two releases within each major version. Questions tagged oracle12c are assumed to be specific to this version or features introduced in this version. A list of features added in Oracle 12c release 1 can be found on Oracle's New Feature Guide for 12c, release 1.

Questions should probably be additionally tagged for the widest readership.

Questions about SQL in general should probably be tagged .

Questions about PL/SQL in particular should probably be tagged as well as .

Questions concerning installation or operation may be asked at Server Fault.

Oracle's documentation is quite extensive, and answers to many questions can be found there. It can be found at:

3970 questions
213
votes
13 answers

error: ORA-65096: invalid common user or role name in Oracle database

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 IDENTIFIED BY tiger; it displays the following…
enu
  • 2,375
  • 2
  • 11
  • 12
113
votes
12 answers

ORA-28040: No matching authentication protocol exception

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.SQLNestedException: Cannot create…
Aman Adhikari
  • 3,240
  • 3
  • 22
  • 32
37
votes
4 answers

How to install Oracle Instant Client on a Mac?

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 under…
Ben
  • 519
  • 1
  • 7
  • 14
33
votes
11 answers

Oracle Joins - Comparison between conventional syntax VS ANSI Syntax

Preamble As of late, I see too many geeks commenting on Oracle questions saying "Do not use (+) operator, rather use JOIN syntax". Question I do see that both work well. But what is the real difference between using them? I would welcome answers…
Srini V
  • 11,045
  • 14
  • 66
  • 89
30
votes
1 answer

how to drop administrative user in oracle 12c

I am not able to drop a user created by me which has administrative rights. I am running below command: drop user GOVIND CASCADE; This is the error I am getting: ERROR at line 1: ORA-28014: cannot drop administrative users
Govind Gupta
  • 1,555
  • 4
  • 15
  • 24
29
votes
7 answers

ODP.NET Oracle.ManagedDataAcess random ORA-12570 errors

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 subsequent request gives the same error for about 10-30…
Edgar
  • 1,097
  • 1
  • 15
  • 25
29
votes
10 answers

Return results of a sql query as JSON in oracle 12c

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 exporting to json with json_encode. The whole…
SWilk
  • 3,261
  • 8
  • 30
  • 51
25
votes
5 answers

Can't open View->DBA Menu in SQL Developer (Oracle 12C Standard Edition Installed)

I have installed Oracle 12C Standard Edition. Everything works fine there. I have also connected the Oracle SQL Developer Client 4.0. From that I can access the tables, indexes etc. I am trying to see the tablespace details from SQL Developer Client…
RobinHood
  • 2,367
  • 11
  • 46
  • 73
22
votes
6 answers

Aggregate Overlapping Segments to Measure Effective Length

I have a road_events table: create table road_events ( event_id number(4,0), road_id number(4,0), year number(4,0), from_meas number(10,2), to_meas number(10,2), total_road_length number(10,2) ); insert into road_events…
User1974
  • 276
  • 1
  • 17
  • 63
19
votes
2 answers

Search a JSON array in Oracle

I'm trying to use the new JSON features introduced in Oracle 12.1.0.2 However I can't seem to find a way to look for a specific value in an array inside my JSON document. Consider the following table and data: create table orders ( id …
user330315
18
votes
1 answer

Why does Oracle add a hidden column here?

We recently migrated a customer system to Oracle 12c and to the latest version of our product. This process includes running a number of migration scripts which mostly add or change tables. We noticed that adding a column to a table while also…
Martin Drautzburg
  • 5,143
  • 1
  • 27
  • 39
16
votes
1 answer

Can oracle read local files when only associated by secondary group?

I am trying to run a very simple python script from Oracle. Oracle is on the same linux box as the script. It opens a file and creates a checksum. It is triggered by a 'recon' user within oracle. Running the script from within Oracle works fine as…
Paul
  • 578
  • 1
  • 8
  • 23
16
votes
9 answers

Oracle.ManagedDataAccess and ORA-01017: invalid username/password; logon denied

I have a challenging situation on one of our servers. I have an ASP.NET MVC 3 application that needs to connect to an Oracle 12c database. It does so using the following connection string: User ID=myuserid;Password=mypass;Data…
DerHaifisch
  • 394
  • 1
  • 5
  • 14
16
votes
1 answer

Oracle identity column and insert into select

Oracle 12 introduced nice feature (which should have been there long ago btw!) - identity columns. So here's a script: CREATE TABLE test ( a INTEGER GENERATED ALWAYS AS IDENTITY PRIMARY KEY, b VARCHAR2(10) ); -- Ok INSERT INTO test (b)…
Kombajn zbożowy
  • 8,755
  • 3
  • 28
  • 60
15
votes
4 answers

How to prevent SQL injection when the statement has a dynamic table name?

I am having code something like this. final PreparedStatement stmt = connection .prepareStatement("delete from " + fullTableName + " where name= ?"); stmt.setString(1, addressName); Calculation of…
Vicky
  • 1,135
  • 1
  • 17
  • 37
1
2 3
…
99 100