Stack Overflow
Stack Overflow

Questions tagged [oracle21c]

This tag is for questions which deal specifically with Oracle RDBMS version 21c. General question regarding the Oracle RDBMS product should use the `oracle` tag.

This tag is for questions which deal specifically with Oracle RDBMS version 21c. General question regarding the Oracle RDBMS product should use the oracle tag.

80 questions
4
votes
1 answer

Oracle Database 21C XE installation error

I am trying to install #Oracle #database XE and I am getting an error : {IDS_OracleConfigDlg_DatabaseConfigFailedMsg} An error occurred while configuring Oracle XE database. Check the logs at C:\app\gn1411\product\21c\cfgtoollogs\dbca and try…
Mwamba
  • 41
  • 2
2
votes
0 answers

How to limit the number of many in the one-to-many relationship in the constraint

One B can have only one A, but one A can be appeared in B up to 3 only. Suppose I have the following code to create new tables: create table A ( A_id number constraint Aid_pk primary key); create table B ( B_id number constraint Bid_pk primary…
pokpkk
  • 21
  • 2
2
votes
1 answer

How to find default password of official Oracle database 21c (images) what run inside docker?

I run docker pull container-registry.oracle.com/database/enterprise:latest docker run -d --name oracle-db container-registry.oracle.com/database/enterprise:21.3.0.0 docker logs oracle-db log C:\Users\fffdfd>docker logs oracle-db [2022:09:15…
Vy Do
  • 46,709
  • 59
  • 215
  • 313
2
votes
0 answers

Should the file ".XE.created" be there?

the docker container "container-registry.oracle.com/database/express:21.3.0-xe" didn't run the post-setup scripts. The post-startup scripts works fine. docker-compose.yml version: '3.3' services: db: image:…
LighthouseBlue
  • 21
  • 1
1
vote
0 answers

Multiplication not working in calculated expression

I am trying to multiply the below two number fields together in a query: SELECT (COALESCE(UNIT_PRICE , 0) * COALESCE(QUANTITY, 0)) FROM PO_LINES_ALL LINE This results in blank values output. As you can see below UNIT_PRICE can either be a whole…
Nick
  • 268
  • 8
  • 33
1
vote
0 answers

Query on a Materialized View becomes very slow after a Refresh

I have Oracle 21c XE using some Materialized Views (MV) for my application. The most used materialized view, MajorView, is based on other secundary MVs A,C,D , i.e. the MajorView is nested MV since it's query references others MVs A,C and D. In…
JRG
  • 513
  • 9
  • 23
1
vote
2 answers

in ORACLE DB SQL, how to do an 'Insert all' statement where i only specify the columns once?

right now i do the following INSERT ALL into "table" (col1, col2, col3....) values (val1,val2,val3...) ... select 1 from dual; However, that requires the sql code to include the columns for each insert (i care about this because i…
Daniel Goldberg
  • 101
  • 6
1
vote
2 answers

What is the concept of PUBLIC exactly in Oracle Database?

What is PUBLIC exactly in Oracle? Is it a role or a user? And does it have a schema? If it has, can we create objects in it? I read many documents saying it is a user group as well. But I got confused about what exactly it is. Any help will be very…
general46
  • 800
  • 6
  • 16
1
vote
1 answer

ORA-22288: file or LOB operation FILEOPEN failed, access denied

I would like to store an xml file in oracle database and I did the following : create table MyTab (filename varchar(64), xml XMLType); create or replace directory XML_DIR as 'C:\Users\XXX\XXX\Folder\xml'; insert into MyTab VALUES ('file.xml',…
Ahmadou Kassoum
  • 59
  • 7
1
vote
0 answers

What is the different between UTF-8 and UTF8 in Oracle SQL developer?

What is the different between UTF-8 and UTF8 in Oracle SQL developer?
Vy Do
  • 46,709
  • 59
  • 215
  • 313
1
vote
0 answers

ORA-12541: TNS : no listening process

I’m actually using oracle 21c express. The problem is the fact the TNS service "OracleOraDB21HomeTNSListener" is missing in all services. When installing oracle 21c I can notice an error message which is « An error occurred while configuring Oracle…
Mohamed Diop
  • 11
  • 3
1
vote
1 answer

NoSuchMethodError: Flow$Publisher OracleConnectionBuilder.buildConnectionPublisherOracle()

I come to you because I am stuck with my Jhipster Spring Boot application, when it comes to using Oracle and r2dbc. Short description of my application I have multiple maven profiles. One is called "dev" and it uses embeded H2 database. Everything…
Kris
  • 401
  • 2
  • 7
  • 16
1
vote
0 answers

I keep getting ORA-00933: SQL command not properly ended what am i doing wrong

CREATE SEQUENCE "MY_USERS_SEQ" MINVALUE 1 MAXVALUE 9999999999999999999999999999 INCREMENT BY 1 START WITH 361 CACHE 20 NOORDER NOCYCLE NOKEEP NOSCALE GLOBAL
Kay
  • 59
  • 4
1
vote
0 answers

21C XE Installation does not start on Windows 10

I try to install Oracle 21C Express Edition on Windows 10 Enterprise(on virtual machine). But after setting installation directory, it does not forward more. "Next" click does not give any response or any error. There was 11G XE before and also 11g…
b_hill
  • 11
  • 1
1
vote
1 answer

Spring Data Jdbc and Oracle21c

for my latest assignment I'm developing a Spring boot application which will connect with an Oracle 21c database. The feature of the oracle release we're interested in is the native JSON data type called OSON (reference here: Oracle 21c JSON data…
drew1927
  • 11
  • 1
1
2 3 4 5 6