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
0
votes
0answers
19 views

How to delete OCR backup?

I have the following backups: sudo /u01/app/19.3.0/grid/bin/ocrconfig -showbackup server1 2020/05/03 00:18:59 +OCR:/rac/OCRBACKUP/backup00.ocr.262.1039393129 724960844 server1 2020/...
0
votes
4answers
67 views

How to start oracle service?

I have 3 instance of oracle database which myservice, myservice1, myservice2. 1st database service name is MYSERVICE; it's working ok But I can't start myservice1 and myservice2. How can I start ...
0
votes
0answers
21 views

Delete interlinked tables data using one query

I want to write the database query to delete the data from multiple interlinked tables. Below is the structure of the database: CREATE TABLE TABLE1 ( ID NUMBER(10), TABLE2_ID NUMBER(10), ...
-1
votes
3answers
33 views

Group by a col and concatenate two non group by col in oracel

I'm getting into SQL for the first time after 9 years of work only into Linux. Just during the course of practising sql i was trying to concatenate first_name and last name and get the avg salary of ...
0
votes
1answer
51 views

“Column check constraint cannot reference other columns”

I get the error "Column check constraint cannot reference other columns" with the table below. How can I solve this? CREATE TABLE SALES_ORDER ( S_ORDER_NO VARCHAR2(6) PRIMARY KEY CHECK (...
0
votes
0answers
18 views

SQL Server Backup on OCI Object Storage

Is there any way I can take SQL Server database backup directly on OCI object storage? Couldnt find any method to map the object storage to windows.
0
votes
2answers
46 views

My Procedure isn't working right. It keeps giving me an error

create or replace PROCEDURE CHECK_BLACKLIST ( P_EMPLOYEE_USERNAME IN VARCHAR2 , P_ROWCOUNT OUT NUMBER ) AS BEGIN SELECT COUNT(*) INTO P_ROWCOUNT FROM boe_safegaurd WHERE UPPER(...
1
vote
0answers
31 views

Pivot rows to columns in Oracle where number of rows-to-columns can only be determined at runtime

Using Oracle 18c and given the following table and data: create table food (type varchar2(20), name varchar2(30)); insert into food values ('fruit', 'apple'); insert into food values ('fruit', 'pear')...
-1
votes
1answer
42 views

Connected to an idle instance

I an facing problem while i connect to sqlplus oracle 112c. Connected to an idle instance. when i run startup command i also face ORACLE instance started. Total System Global Area 2550136832 bytes ...
0
votes
0answers
26 views

Decrypting data in SQL Server from another source

I'm an Oracle DBA that is learning SQL Server. I have data that was replicated from Oracle to SQL Server 2017 that I need to be able to decrypt in a controlled manner by queries on SQL Server. I ...
0
votes
1answer
35 views

SSMS Linked Server -ORA-28009: connection as SYS should be as SYSDBA or SYSOPER (Microsoft SQL Server, Error: 7303)

How could I use "Linked Server" from SSMS IDE to connect the Oracle server database with "SYSDBA"? I've tried many methods as following to show you what I did right now: Oracle client connect to ...
-1
votes
0answers
19 views

What is the absolute minimum allocated memory Enterprise Oracle 12c can survive in on Win Server [closed]

Very low transaction pressure, memory is a hot commodity on the box, single instance installation on a Windows Server. Hardware resources are fixed at 4GB RAM only. Existing environment - can not ...
-2
votes
1answer
34 views

Oracle Delete From a View [duplicate]

I need to compile below query: delete from dba_audit_trail where TIMESTAMP > SYSDATE - 30; But it doesn't allow to delete from a view. I HAVE TO delete records from dba_audit_trail, I can't use ...
0
votes
1answer
37 views

How to select from table by comparing multiple rows with same key

I have below table KEY_STATUS. || KEY || STATUS || | 0001 | FAILED | | 0001 | COMPLETED | | 0002 | FAILED | | 0003 | COMPLETED | | 0002 | FAILED | | 0004 | STARTED | I would like to ...
0
votes
1answer
36 views

ORA-00604: error occurred at recursive SQL level 1

I was compiling a package on an Oracle Database just fine and suddenly this error occurred: ORA-00604: error occurred at recursive SQL level 1 ORA-01654: unable to extend index SYS....
-1
votes
1answer
36 views

Database not opening, after messing with datafiles [closed]

I was exercising some database recovery exercises First I had made a backup of my datafiles, then I moved them to another directory to test if I could recover them or not. When I was recovering them ...
0
votes
1answer
29 views

ASM trying to mount droped diskgroup

In my envoriment I am getting the following erro: ORA-15032: not all alterations performed ORA-15017: diskgroup "OCR" cannot be mounted ORA-15040: diskgroup is incomplete The problem is: I already ...
-1
votes
1answer
42 views

How To Delete Record From dba_audit_trail in Oracle 11gR2

I want to delete records older than one month from AUD$ table, but I have to do this on dba_audit_trail, because I have to do this job according dba_audit_trail's timestamp. I can't find any clear ...
0
votes
1answer
14 views

Filter rows by range dates and only get the rows in a range of hours

I want you to filter the rows between a date range but I only want you to return the rows of a time range of each of the days included in the previous date range. For example, you would like to ...
0
votes
0answers
16 views

BFILE datatype in mysql

My backend is writing The Soap request within a table using a BLOB column so that I have very big tables in mysql with more of 100GB. I need store this information out of dabase in file for example. ...
1
vote
0answers
49 views

How do I configure Oracle DB 11g Enterprise to be able to be accessed from HTTPS PORT?

I'm trying to create a TSA Listener so I could access my Oracle database from HTTPS Port. I already checked edelivery.oracle.com but I found no Web Tier for Windows. Is there any other way for me to ...
0
votes
1answer
31 views

Load test with databases. Best practices , tools [closed]

I need to design a way to stress a clon of my production databases. At the moment, I'm using mysql percona xtradb with tree nodes running in google cloud. I'm using haproxy as load database balancer. ...
-1
votes
2answers
42 views

Flash Area Full - Actions

I have seen some recommendations in the Oracle Docs about what to do if the FRA is full. For example I have this config also: CONFIGURE ARCHIVELOG DELETION POLICY TO BACKED UP 1 TIMES TO 'SBT_TAPE'; ...
0
votes
2answers
52 views

How to backup Oracle Production Database without stopping service?

I have a Oracle 18XE database I would like to create a backup for the database. I did : expdp sysdba full=y dumpfile=expdat.dmp directory=DatabaseDumps transportable=always logfile=export.log But ...
0
votes
0answers
46 views

Oracle Apex: catcon::wait_for_completion: unexpected error in next_proc()

I am trying to install oracle apex 19.2 on Oracle 18C XE edition . But while installing I am getting below error message after running @apexins.sql sysaux sysaux temp /i/ catcon::wait_for_completion:...
0
votes
2answers
30 views

Oracle limit the number of files of audit

I would like to know how to limit the number of files of audit generated in the audit directory, I have an Oracle 12c database. The AUDIT_TRAIL parameter is equal to NONE, however it continues to ...
0
votes
2answers
29 views

Postgresql MVIEW refresh from Oracle Materialized View Log

Is it possible for me to have Oracle MVIEW log in my source database and refresh a Postgresql database MVIEW using this MVIEW log? I know I can query the MVIEW log, I have done that. But since it is ...
1
vote
1answer
45 views

How to remove spaces between words and replace with single underscore using 'REPLACE','INSTR' OR 'SUBSTR' oracle function

I want to replace spaces between words with a single underscore. I can't use the replace_regex Oracle function to do this, because it is not supported by the converter which we are using to convert ...
0
votes
1answer
26 views

Oracle data Guard status (active/passive)- version 11g

I have 2 servers: Primary (ABCUAT) and Standby (ABCUAT1) configured as Active-Standby DataGuard by previous DBA. When I took over the system, I think DataGuard was not in sync, but I could not ...
0
votes
3answers
39 views

How can I troubleshoot TNS connection issues? Do I need TRCROUTE executable?

I am trying to connect to a particular TNS name; in my tnsnames.ora file I can see that it is defined as being a TCP connection to foo-scan on port 39000. I can tnsping this name OK. I can ...
0
votes
1answer
25 views

Read only privileges

I have created a user and want to grant the user read only privileges on all database schemas. Can I do that using a single grant statement for all 20 schemas.
0
votes
1answer
19 views

Oracle 19c Installer Can't Select National Character Set

I am trying to install a new 19c instance of Oracle database in order to migrate a 12c database there. The 12c database uses a database character set of WE8ISO8859P1 and a national character set of ...
1
vote
1answer
55 views

Does interrupting ALTER INDEX COALESCE CLEANUP lose the work so far?

In Oracle 12c (12.1) we have a huge partitioned table with interval partitioning. Beside local indexes, there are two global indexes on it. Dropping old partitions with UPDATE INDEXES clause helps the ...
0
votes
1answer
27 views

Delete/Modify row in one table based on a condition

I have a table structure like create table EMPLOYE ( CodeEmploye varchar2(100) not null, NAS varchar2(100), CONSTRAINT employe_pk primary key (CodeEmploye) ); create table SALAIRE ( ...
0
votes
0answers
43 views

Is there a better way to join 4 tables?

hope you're doing well. I have 4 tables as below: z_branchlf_user :(USER_NAME,BRANCH_CODE) Z_BRANCH_TO_CUSTOMER :(CUS_NUM, BRANCH_CODE,REL_CODE) z_fact_customer_branch :(EFFDATE , CUS_NUM , ...
-2
votes
1answer
37 views

Am not able to execute the update stmt using Multiple Joins..SQL DEVELOPER [closed]

UPDATE artikel A SET A.art_haccp = (SELECT DISTINCT a.art_haccp FROM artikel A, warengruppe W, sparte B, ...
0
votes
1answer
85 views

Migrate SELECT query from oracle to postgresql

I want to migrate an oracle query to postgresql : here is the oracle version : SELECT replace(replace(replace( cf.NO_FACTURE||';'|| cf.MODULE||';'|| replace(replace(replace(cf.REF_FACTURE_SYBEL,'&...
2
votes
2answers
93 views

Tuning Java Pool after getting ORA-04031

I'm running Oracle 12.2.0.1 Standard edition on Windows 2012 RC2. I'm NOT running Oracle's Automatic Memory Management. We are seeing these in the alert log: ORA-04031: unable to allocate 4096 ...
1
vote
1answer
43 views

Grant rights to create a table with an identity column on another schema

I have a user in charge of deploying DDL on other schemas than its own. This user can create a table on those schemas, it can also create sequences on those schemas. But when I try to create a table ...
0
votes
0answers
91 views

Got Error after trying given code

I tried the code in this answer for 'How can we get the table and the column name of known data value?'. However, I get this error when tried the code which is also shown below, I am looking for a ...
-1
votes
1answer
40 views

The best way to patch Oracle Rac One Node [closed]

what is the best way (best practice) to patch Oracle Rac One Node (2 nodes - node1 and node2, every node has own database home and GRID home = 4 homes)? Thank you System: Oracle Solaris 11 DB: ...
0
votes
0answers
20 views

Is it possible for a FOR LOOP cursor execute operations asynchronously?

I was having a problem in which the number in a table isn't updated between each commit, it was supposed to be incremented 1 by 1 but it was been incremented 2 by 2, I included logs between the ...
0
votes
2answers
46 views

Is it possible to limit connecting users to a schema from specific terminal or program?

I read about Oracle ACL, but on first sight, it doesn't look like it limits the access to a schema on terminal, program level. Is it even possible? I did experience such limitation once. I was ...
-2
votes
1answer
26 views

bad dump specification [closed]

when trying to import a database to a local machine I get this error: [oracle@9250f1edf0c7 /]$ impdp user/pass dumpfile=EXPDPDAT-OWNER.dmp directory=dpump_dir1 content=ALL REMAP_TABLESPACE=INDEX:DATA ...
0
votes
0answers
17 views

Export the table results into a text file automatically using sql developer

I have a table with contents as below +-----------+-------+ | Name | Value | +-----------+-------+ | IHA_NAME | Rexon | | IHA_Value | 65 | +-----------+-------+ I want to export this data ...
0
votes
0answers
43 views

Why would a very simple Oracle query use a large amount of shared memory?

I have a very simple query which is as follows: SELECT blob_column, varchar2_column FROM table WHERE number_column = ? AND code_column = ? This will find one row by the primary key. This shows as ...
0
votes
0answers
143 views

Oracle SQL query - not exist taking too long

i am trying to fetch the details for those customers who did not shop last year but shopped in current year, i am getting the results, however it is taking too long to execute. is there a better way ...
0
votes
1answer
23 views

Speeding up linking Oracle tables in Microsoft Access

Many people in my office use Oracle tables by linking them in Access (either 2010 or 2016) databases. They always complain about the fact that, when Access is about to present them the list of tables ...
0
votes
0answers
50 views

Is there a way to optimize the query if we are using ROUND function 100 times in a single query

The below query is to compare the last day of the month and select either zero or a value. I am not pasting the entire query as its huge and the i am just pasting the condition which if possible can ...
0
votes
1answer
41 views

Can someone help me with the SQL Server syntax for the my Oracle query

Oracle version: CREATE OR replace PROCEDURE Item_reco_recordset (p_depositid IN NUMBER, p_b1 IN NUMBER, ...