Questions tagged [oracle]

All versions of Oracle database. Add a version-specific tag like oracle-11g-r2 if that context is important in the question. Do not use for Oracle products such as applications or middleware or other database products owned by Oracle, like MySQL or BerkeleyDB.

Filter by
Sorted by
Tagged with
-2 votes
0 answers
20 views

what is the best low cost storage solution for Oracle database BI reporting database?

we are trying to create BI system in our company, the BI database will be synced with the production database ( SYSDATE-1 ) means current day data will not be sysced , the database is a huge around (...
user avatar
1 vote
0 answers
16 views

Oracle 19c: Sql.Recovarable.Exception [Error 17410]

We get an exception while making this call from our backend to the database: select f.* from T t inner join CATEGORY Category on Category.ID1 = t.ID1 where Category.ID2 = ? and t.ID3 = ? and Category....
user avatar
  • 11
0 votes
0 answers
20 views

RMAN ORACLE issue

I have the issue when I run the command RMAN as mentioned below : Please any help
user avatar
  • 1
0 votes
0 answers
18 views

Oracle 19c / Rman-10038: Database Session For Channel channel_name Terminated Unexpectedly

I am getting this error while database restore. This is the first time such an error has been getting from a process that has had no problems for a long time. Backup files are on NFS mount. Total ...
user avatar
1 vote
3 answers
45 views

Can someone help explain the specifics of why a DBA would be against database clustering?

I'm a system admin and do not manage databases on a daily basis. My organization is considering database clustering to practically eliminate downtime for certain services. We use mostly oracle ...
user avatar
0 votes
0 answers
24 views

Object necessary for warmstarting database cannot be altered ORACLE

I have this error when I want to rebuild system index : 00701. 00000 - "object necessary for warmstarting database cannot be altered" *Cause: Attempt to alter or drop a database object (...
user avatar
  • 1
0 votes
2 answers
29 views

ORA-01555: snapshot too old error when deleting with transactions

I hope someone can explain me why I'm seeing ORA-01555. I have a function and a procedure to perform a cleanup in a huge table: -- Small cleanup in separate transaction. FUNCTION clean_single(ts_until ...
user avatar
  • 101
0 votes
1 answer
20 views

Proper way to setup oracle database for TCPS SSL in local machine

I am using oracle database 12c and would like to setup TCP SSL connection to be able to connect using the same machine where the database is hosted. So, connection would be from database machine to ...
user avatar
0 votes
1 answer
14 views

Create a database link as a user while current schema is different

I have the following situation in an Oracle database. I am user Bob on a local database, LOCAL, and the current schema I am in is not the user's schema, but a different one, let's say Alice. What I ...
user avatar
  • 103
2 votes
1 answer
20 views

RMAN decrypted backup of Oracle TDE encrypted table

I have a Database with Transparent Data Encryption enabled across tablespaces. We have a storage appliance we're using RMAN to backup to which has native encryption, deduplication and compression ...
user avatar
0 votes
1 answer
27 views

Oracle not allowing large fields for common users after setting max_string_size=EXTENDED

I'm using an Oracle 19.3 enterprise Docker container and enabling max_string_size=EXTENDED. When creating a table with a large field using the sys user, Oracle allows the table to be created. But when ...
user avatar
  • 103
0 votes
0 answers
14 views

Can I run scheduled job as sysdba?

I have user c##admin in my core DB (Oracle 19c), with "sysdba" privileges. I want it to select from a pdb using a database link without giving a password. assuming the following: PDB Name: ...
user avatar
  • 794
0 votes
0 answers
9 views

Best approach to calculate PCTFREE for tables with high chained_row_ratio after ANALYZE TABLE xxx LIST CHAINED ROWS

On two different databases (Oracle 12.1, 19.11) I've seen in V$SESSTAT a high ratio of "table fetch continued row" of at least more than 10% and I'm searching a good approach to calculate a ...
user avatar
0 votes
1 answer
28 views

Performance Problem : PL/SQL

SELECT NULL AS TRX_NUMBER , NULL AS CUSTOMER_TRX_ID , VW_SAP_MPP_INV1.DOCENTRY AS DOCENTRY , VW_SAP_MPP_INV1.LINENUM AS LINENUM , VW_SAP_MPP_INV1.ITEMCODE AS ITEMCODE , VW_SAP_MPP_INV1....
user avatar
2 votes
1 answer
55 views

How to Avoid SQLPlus output truncating

I have the following column in oracle database table. Column name : objectdata Data type : LONG RAW When I query this column via sqlplus output is like below. SQL> select objectdata from tableA ...
user avatar
  • 223
0 votes
1 answer
19 views

Oracle 21c XE, need install/enable JServer JAVA Virtual Machine, but ORA-00904

In Oracle 21c XE, I need install/add JServer JAVA Virtual Machine. When I try to install it, there is a problem, exactly ORA-00904: "PSU_VER": invalid identifier. SQL> @?/javavm/install/...
user avatar
  • 151
0 votes
0 answers
9 views

how to select multiple columns from different tables in a single case statement using BigQuery

i have the below query testing in Bigquery how do i populate the data values directly from the table.column ? case when table1.languagecode like '%EN%' then 'Y' when table1.languagecode is null then '...
user avatar
  • 101
0 votes
1 answer
26 views

Add new column based on conditions and the value difference of other column

I think I might be overlooking something obvious here. I'm not asking someone to write the whole code for me, I just need a hint or a link to a similar case. Thanks in advance... My query: select ...
user avatar
-1 votes
1 answer
31 views

Replication between two Cloud Services

Is it possible to implement SQL Server Replication between two disparate cloud services? For instance, if I have an instance running in Amazon's AWS Cloud Service and another instance running in ...
user avatar
1 vote
1 answer
26 views

Oracle 19 - RMAN can't connect to database

I have troubles with starting RMAN and connecting to target database. I start RMAN ($ORACLE_HOME & $ORACLE_SID env variables are set) [oracle@MY_MACHINE /]$ /u01/app/oracle/product/19.0.0/dbhome_1/...
user avatar
  • 13
0 votes
1 answer
37 views

Failing to enable TCPS on Oracle 11

I have added the following settings to my Oracle 11 server (Bolded text is the change)- sqlnet.ora- SQLNET.AUTHENTICATION_SERVICES = (**TCPS,** NTS) listener.ora- SID_LIST_LISTENER = (SID_LIST = ...
user avatar
-4 votes
1 answer
26 views

create a oracle database user with no object in tablespace [closed]

Create user Sara with a password of sara. Make sure that any objects not created in the system tablespace and Sara can log in and create objects up to 10M in size in the MYUSERS. how to create a ...
user avatar
0 votes
2 answers
36 views

Query optimization [Oracle DBMS]

I have a query that always must return a single row and its execution time is about 5s, so I need to optimize it: SELECT * FROM RESPONSE res INNER JOIN REQUEST req ON res.ID = req.ID WHERE res....
user avatar
0 votes
1 answer
14 views

ORA-02270 - can FK in Oracle be defined on VARCHAR2 column?

SQL is more than words: CREATE TABLE "currency" ("id" NUMBER(10) NOT NULL, "currency" VARCHAR2(50) NOT NULL, "name" VARCHAR2(1020) DEFAULT NULL NULL, PRIMARY ...
user avatar
  • 396
0 votes
1 answer
18 views

Query Over Oracle DB Link Requiring global_name = true

I'm running the following queries over a private dblink (Oracle Database 19c): delete from myschema.mytable@mydblink where SERVER = (select host_name from gv$instance); insert into myschema.mytable@...
user avatar
-2 votes
1 answer
23 views

AWS TO OCI GOLDENGATE REPLICATION

I want to use oracle Goldengate to my Multi cloud setup database, I'm just wondering if Im required to down my primary database to avoid data discrepancy? or goldengate can sync the data even if my ...
user avatar
0 votes
1 answer
119 views

export multiple tables using expdp with query condition

I have requirement to export multiple tables using datapump job and the ultimate goal is that we are doing a migration from on-Prem . They have something like 6TB of AUD data and we are not required ...
user avatar
  • 50
0 votes
1 answer
22 views

Is it possible to set Audit_trail parameter to both DB and OS in Oracle database

In Oracle database ,we can direct audit records to either db , os or in xml file by using the below command: ALTER SYSTEM SET AUDIT_TRAIL= DB SCOPE=SPFILE; But is it possible to direct audit records ...
user avatar
  • 1
0 votes
2 answers
64 views

How to startup the Oracle Database 19c without using parameter pfile?

Dears, I am starting my Oracle database using the following startup code. Can you help me how to startup without the parameter. SQL> startup pfile='E:\app\oracle\admin\prod\pfile\init.ora....
user avatar
0 votes
0 answers
10 views

estimate total number of updated/locked rows in a transaction by SID

How can a DBA estimate the total number of updated/locked rows in the current transaction knowing the SID? I want to monitor the progress of a long operation in a 3rd-party software.
user avatar
  • 223
-2 votes
1 answer
54 views

Which modern IDE to use when working with Oracle database? [closed]

Good afternoon! I am working with Oracle Database (mostly writing queries, stored procedures and creating tables). The problem is that I can not find a modern IDE to work with Oracle such as Visual ...
user avatar
  • 1
0 votes
0 answers
13 views

Missing file after adding multiple files to the tablespace in Oracle

I ran a series of 100 commands in SQL Developer: alter tablespace RRODTBL add datafile '/oradb/PRODDB/data4/prodtbl_171.dbf' size 10M autoextend on next 128M maxsize 31G; alter tablespace RRODTBL add ...
user avatar
  • 1
0 votes
0 answers
25 views

Does Oracle Enterprise Multi-Master Replication negate the need for Data Guard (Active or not)

Does Oracle Enterprise Multi-Master Replication negate the need for Data Guard (Active or not)? If I deployed a 3 member cluster of Oracle Enterprise (on EC2 not RDS) across 3 availability zones in ...
user avatar
0 votes
0 answers
27 views

How to connect to Oracle 9i through SSH tunnel if TNS protocol issues a REDIRECT to a random port?

Inspecting packets exchanged between SQLDeveloper and Oracle 9i I noticed that, in the beginning of the connection negotiation, the server issues a REDIRECT back to the client, pointing a port ...
user avatar
  • 133
0 votes
0 answers
28 views

Oracle: why does this DDL yield a different result in production (reordering of columns)?

Problem description This week we had an issue in production, where an SQL script that was executed ended up with a different result than what we had tested before locally, in Docker and on our ...
user avatar
  • 173
0 votes
1 answer
33 views

Different time sysdate and current_date when connect to database since application server

I have a problem with the time that Oracle gives me when working with applications. I currently connect from an application server (apx1) to a server containing Oracle 19c (bdx1) for database ...
user avatar
  • 133
1 vote
1 answer
20 views

SingleStore Execute Immediate a SP/Func inside SP from a query table

I’m having trouble to execute immediate a SP inside a SP from a table. because i have a lot of SP stored in a table (as a data/string). in oracle we can use “select sp_1(:1,:2) from dual” and running ...
user avatar
0 votes
1 answer
40 views

Oracle 12c missing GSMADMIN_INTERNAL

Oracle 12c 12.2.0.1 The GSMADMIN_INTERNAL user was erroneously deleted apparently some weeks ago. Datapump no longer works for export (ORA39006 and 390065) as well as ORA-00942 table or view does not ...
user avatar
-1 votes
2 answers
28 views

Find in what table I can find multiple collumns

I am trying to write a query that will show me the tables that contains all the following columns: ProductGroup, ProductClass and ProductID. But I am not very successful at it. Can somebody help me ...
user avatar
0 votes
1 answer
23 views

oracle - Calculate sum or avg in one query based on the their value

I've this table date customer amount percentage category 20220330 customer1 10 93 01 20220330 customer1 11 91 01 20220330 customer1 13 91 02 20220330 customer1 15 91 02 I' need to calculate sum ...
user avatar
  • 141
0 votes
1 answer
23 views

Manually change datafile size or let oracle do the job during schema duplication

I have to duplicate a (relative) big schema inside the same database (using impdmp). I know Oracle will automaticaly enlarge the data file during the import. What is the right way : let Oracle ...
user avatar
1 vote
1 answer
62 views

SingleStore exception no_data_found

I’m having difficulty finding the exception no_data_found in singlestore. In Oracle, we use no_data_found exception. Is there any alternative solution in singlestore for the no_data_found exception?
user avatar
2 votes
1 answer
237 views

How to terminate user's sessions in Oracle DB exactly 8 hours after user connected?

I would like to terminate user sessions (and optionally also lock the user), exactly 8 hours after user established DB connection. I tried creating a profile, but it just doesn't terminate user's ...
user avatar
  • 123
1 vote
0 answers
104 views

impdp: ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1'

I'm trying to import a large database, and after a while I get: ORA-30036: unable to extend segment by 8 in undo tablespace 'UNDOTBS1' I know this has been asked before, but I can't find a clear ...
user avatar
  • 111
0 votes
0 answers
28 views

Best approach for purging records (including related records) from an Oracle database with undo capability?

Please let me know which approach you would take. The problem I have a large Oracle 11g DB that needs to have old records purged to free disk space. One of the requirements for the project is that we ...
user avatar
0 votes
1 answer
34 views

Cannot connect to a pluggable database via IDE

I have an Oracle XE database on computer1. When I try to connect to it via sqlplus from computer2, it works fine, for both cdb and pdb connections; e.g.: rlwrap sqlplus timon@//192.168.0.115:9121/...
user avatar
0 votes
1 answer
37 views

Access Oracle Database remotely via DBeaver

I have two machines, a windows 10 notebook with oracle database installed, and a Raspberry Pi 4 with DBeaver installed. On the Raspberry I have PostgreSQL which I can access locally via dbeaver, but ...
user avatar
0 votes
1 answer
33 views

schema ownership/permissions in MS-SQL vs Oracle

Hopefully I'm using the write terms here. I'm pretty good with concepts usually but don't always know the technical terms to describe it correctly. Here goes... I'm used to working in MS SQL Server ...
user avatar
  • 173
2 votes
3 answers
152 views

Update statement runs for longtime and throws ORA-01654 table space error

I have a simple update statement which runs for a long time (>15mins) to update approximately around 120K records in oracle19c,but it also fails atlast with ORA-01654 table space error. Is there ...
user avatar
  • 123
-2 votes
2 answers
66 views

Is the SQL dialect in SQL Server closer to Oracle or to Postgres?

There is an existing application that supports having its data in an Oracle database or a Postgres database, through JDBC. The tables and data are the same, but it can be installed in any of them, to ...
user avatar
  • 112

1
2 3 4 5
151