Skip to main content

Questions tagged [oracle-21c]

Oracle database version 21c. Please also tag [oracle] for search purposes.

Filter by
Sorted by
Tagged with
0 votes
1 answer
137 views

Oracle 19c and 21c expdp exports dumpfile of 308kb without any content

Trying to export schema using the following command on several Oracle instances: two 19c and one 21c $ expdp mySchema/myPwd@ORCL Adding CONTENT=ALL or SCHEMA=mySchema or SCHEMA=MYSCHEMA or DUMPFILE=...
Vy8's user avatar
  • 1
0 votes
0 answers
90 views

Oracle Database Error - ORA-01578: ORACLE data block corrupted (file # 17, block # 955795)

I have a big table with more than one hundred million records, it has this schema. schema of the table: CREATE TABLE USER_B.BIG_TABLE ( field1 NUMBER (10), field2 NUMBER(19,0), field3 ...
M_Gh's user avatar
  • 101
1 vote
0 answers
33 views

Possible explanation for why "SELECT" query executed from JDBC returning just the first row in the table

I installed OracleDB(XE - free version) and I tried to use it in Java. I have this code: static final String DB_URL = "jdbc:oracle:thin:@localhost:1521/XE"; static final String ...
Bogdan Floareș's user avatar
2 votes
1 answer
662 views

How to know how much memory is used by each DB user in the cache buffer?

Using this query: SELECT A.CACHE_BUFFER_TOTAL, B.CACHE_BUFFER_USED, A.CACHE_BUFFER_TOTAL - B.CACHE_BUFFER_USED AS CACHE_BUFFER_FREE FROM (SELECT BYTES / 1024 / 1024 ...
Isaac PM's user avatar
0 votes
0 answers
125 views

What’s wrong with provided apex instance administrator password

1 I have installed Oracle Database 21c Enterprise Edition on Oracle windows 10 I am now trying to install Apex 22.2 . Got to the chapter "5.4.2.3 Running apxchpwd.sql" to set the instance ...
Prabhali Pawar's user avatar
0 votes
1 answer
684 views

Connect to remote Oracle database from local SQL Developer client

I installed Oracle Linux 21c on the remote machine, tested it in Linux shell, and it worked as expected (I can query the testing table I created). But I am stuck when trying to connect to the database ...
geopark's user avatar
0 votes
1 answer
1k views

Set lsnrctl on Oracle XE 21C to listener.ora in file

I installed Oracle XE 21C on an old laptop running Oracle Linux 8.6. I followed the official documentation without getting any errors. I am trying to set the lsnrctl to the one located in /opt/oracle/...
Smooth Researcher's user avatar
0 votes
1 answer
47 views

Oracle CACHE and STORAGE IN ROW behaviour

We have a Java Spring boot application that writes 20 million plus rows in a table with 2 blob columns in a batched manner into an Oracle 21c DB. We are using JDBC batch insert for fast inserts. ...
humbleCoder's user avatar
1 vote
1 answer
3k views

On Oracle 21c XE, what should ORACLE_HOME and TNS_ADMIN be set to?

In my Windows Oracle 21c XE installation I have the product installed under: C:\Oracle\product\21c Below that there is: dbhomeXE which contains the bin directory and also network. However, I also ...
rghome's user avatar
  • 143
1 vote
2 answers
136 views

db<>fiddle (Oracle): Query works in 18c, but not 21c

I have a Oracle query that I use to analyze the vertices of SDO_GEOMETRY polylines: WITH lines AS (SELECT SDO_UTIL.FROM_WKTGEOMETRY('MULTILINESTRING ((0 5 0, 10 10 10, 30 0 33.54),(50 10 33.54, 60 10 ...
User1974's user avatar
  • 1,477
2 votes
1 answer
898 views

Return a resultset as JSON text—using pretty formatting

In Oracle 21c, it looks like we can return a resultset as JSON text: SELECT json_object(*) from dual; result: {"DUMMY":"X"} That works in db<>fiddle: Question: Is there a ...
User1974's user avatar
  • 1,477
0 votes
1 answer
1k views

Does Oracle Database support nested transactions?

Does current version of Oracle Database (21c) support nested transactions? I'm aware of Oracle DB supporting savepoints. However I'm looking for a way to make COMMINT not to write to disk for purpose ...
czerny's user avatar
  • 523