All versions of Oracle. Also add a version-specific tag like oracle-11g-r2 if that context is important in the question.

learn more… | top users | synonyms

0
votes
0answers
4 views

oracle sql developer

this is my script...i don't know why this is not running.thank in advance for those who will help to solve my problem :) .. the eff_year and the from_year is not the same btw... select bracket, ...
0
votes
1answer
7 views

How to find out to which roles tables belong?

I was wondering if there is a way to find out what roles 2 tables reside? I have 2 tables and I want to find out to which role they belong? Is there a way to find out? Thanks
1
vote
1answer
13 views

Map ASM files to physical Linux Devices

We are having problems with log file sync waits periodically. We have a 2 node RAC cluster using ASM. I'd like to monitor the physical device(s) containing the REDO log files using iostat, but I'm ...
0
votes
0answers
9 views

Is there a way to compare very short periods of activity in Oracle?

I am having a problem with an application that requires very low latency (less than 100 ms per txn.) Every once in a while we will see spikes where transactions take 20-30 SECONDS. We looked at the ...
0
votes
1answer
18 views

SSRS 2012 Report with Oracle database as datasource never finishes

I am investigating a SSRS 2012 Report which used to return data from an Oracle database. However, recently it stopped returning data. The report will sit there and run forever until something times ...
0
votes
0answers
19 views

Oracle; Table column reducing fails with 'value too big' error although such data doesnot exist

I am importing data for a table from one server to another server (both tables are of same structure) with command like below insert into table1 select * from table1@dblink1; The table1 has a ...
1
vote
1answer
35 views

I need to merge two queries with condition

I have the following query: SELECT URYRR_FORWARDS_REC_H.CB_LINE as "CB_LINE", URYRR_FORWARDS_REC_H.CB_LINE_DESCRIPTION as "DESCRIPCION", URYRR_FORWARDS_REC_H.UYU_BALANCE_FW as "MONEDA LOCAL", ...
-3
votes
1answer
43 views

Finding the mismatch column names

I have two datasets, both having same column names and just one row. I want to display the column names for which there is a mismatch of column values. Could anyone please suggest how this can be done....
1
vote
0answers
22 views

What might be the cause of regular periodic slow transactions on an OLTP system?

I have a two node Oracle RAC cluster with that runs an oltp application against it. I have both a production and a duplicate test environment with the same setup. Upon running stress tests on the ...
0
votes
0answers
13 views

Issue with Linked Server query

I have a job which fetches data from an Oracle 12c database and inserts into a SQL Server 2012 database, via a linked server from the SQL side. It's a simple Select * statement and just pulls in any ...
1
vote
0answers
15 views

How to Move a whole partition to another tabel on another database?

Database: Oracle 12c I want to take single partition, or a set of partitions, disconnect it from a Table, or set of tables on DB1 and move it to another table on another database. I would like to ...
-1
votes
1answer
27 views

unique constraint on a column with duplicate values

How to create unique constraint on a column with duplicate values,without disturbing the existing data.i have already tried the method below, To create a normal index first and then create a unique ...
0
votes
0answers
26 views

Dropping database in RAC

I need a drop a database which is a 2 node RAC configuration and I will also be drooping the disk groups as well completely. What is the right way to drop the database + diskgroups? Will it be ok to ...
-1
votes
1answer
24 views

Select catalog role - Oracle

Does select_catalog_role if granted to a schema provide access only to dba tables and v$ views only and not to other schemas created for any application? The reason i'm asking this is I need to grant ...
-1
votes
1answer
26 views

how to drop oracle 12c instance on linux

I have created an Oracle 12c container db instance. I need to drop the instance. What's the most effective way to drop instance?
0
votes
0answers
26 views

Oracle SQL subquery Optimization

Hi I have table called TABLE1 that is Indexed by date DT, and Item ITEM respectively. I need to write a query that will retrieve for me a list of items, for month end for given amount of months. So ...
0
votes
0answers
30 views

SQL Retrieval Into Excel HELP! [closed]

The picture shows the format of E1 to maybe help out visually. I'm an intern and I work for an engineering company. As a project, I want to streamline the document control [DC] process and save time. ...
0
votes
1answer
25 views

Trying to compare several similiar lists on one table to produce a concatenated result

So imagine that four friends are planning on moving into a house together. They put together a list of stuff that they all own. Obviously, there is some overlap but there is also unique things among ...
0
votes
1answer
29 views

How to connect to an Oracle db using a stored procedures within a Microsoft SQL server? [closed]

I need to verify data between an Oracle db and a Microsoft SQL Server db to verify that if there differences between the two and then update the Microsoft SQL Server with any changes there may be. ...
0
votes
0answers
42 views

Help with slightly complex ORACLE query

I have 2 tables: HEADER has the following field: IDENTIFIER, NOTE, GROUP_ID QUEUE has following field: PARAMETER, OPERATOR ... An example records would look like: HEADER: MY_STUDY_123456 (...
0
votes
1answer
51 views

Should i expect to execute of 160billion iteration from oracle 11g?

I have a table that contains approximately 390 000 records and up to now I found 3 different algorithm(solution) for my problem. Each algorithm require cartesian product of table with itself. I am ...
0
votes
1answer
22 views

RMAN Control File Information

I have daily full backups going on for my Oracle 12c databases on linux. Daily retention on disk is 6 days. This is what happens: Full backup happens at location /orcl_bkup/backup_full After ...
0
votes
1answer
22 views

Replace function with dynamic query on a stored procedure (Oracle) [closed]

I have a field street name that would accept names like : O'connor but I have tested with replace function that works fine, but not sure if this is going to cause an exception with numeric values(int)....
2
votes
2answers
57 views

UNION ALL w/ MINUS

Why does: select 1 FROM DUAL UNION ALL select 1 FROM DUAL MINUS SELECT 2 FROM DUAL return only a single 1 rather than 2 rows of 1 in Oracle?
1
vote
0answers
41 views

Check if 1/3 Queries Evaluates to True

My large (+100 line) query contains a WHERE filter similar to: select * from (<complex 100+ line query>) d WHERE ( (EXISTS (select 1 FROM TABLE1 t1 WHERE d.dummy = t1.x ...
0
votes
0answers
32 views

Error PROT-23, ocr manual backup

Everyday I have a manual backup of ocr in a rac instance 11.2 and It works fine, but this night the backup failed with PROT-23 error. Now I try to execute it and allways fails. I execute with root ...
0
votes
1answer
36 views

Oracle sql combine several rows of the same table into one row

I have a table where for each given ID, three rows are generated as shown. The first row is the header row: +-------+------+-------+------+-------+----+----+----+ | ID | GRP | ITDESC| DEN | NUM ...
-4
votes
0answers
39 views

Retrieving the data based on id from table contains 2 million rows [closed]

I have one table/collection contains 2 million rows/document (id(20 alphanumerical digits), name, ... etc). From that table I want to retrieve data based on the id within 1 sec Which database ...
0
votes
0answers
21 views

Oracle Report 12.2.1.1.0 Configure Issue

I installed Oracle 12c and Oracle frm 12.2.1.1.0 on my laptop(w10/64bit) properly and Oracle form server and form are run properly. But unfortunatly the report builder doesnt work properly. Report ...
0
votes
0answers
28 views

Hyper-V as Oracle Client failling to connect at Host Oracle Server [closed]

I have a Windows 8 Server (as host) running Hyper-V with a Windows 2012 server (as VM) On Host I installed the Oracle 10g (server version) and the Client 11g at the VM. At VM when I try to connect ...
-1
votes
0answers
33 views

How do I install Oracle12c and then connect through SQL Developer? [closed]

I am having trouble installing Oracle12c and then establishing a connection. I have downloaded both files from Oracle's website for windows x64. I have read through the Oracle documentation on their ...
0
votes
1answer
36 views

Trigger to delete with cascade effects [closed]

Hi I am new to Oracle triggers. Your help will be much appreciated! I have the following 2 tables: Product: CREATE TABLE Product (prodId varchar(10) NOT NULL PRIMARY KEY, prodName varchar(30) ...
0
votes
1answer
21 views

cant access both phone numbers in my nested table type

Im using Oracle Developer and I have a customers table where each customer has 1 home-phone number beginning with 0131 and either 1 or 2 mobile numbers. I am trying to display the customers name and ...
0
votes
1answer
39 views

Oracle multiple databases on same server [closed]

I want to be able to import multiple database dumps locally and be able to switch between them. What I would like to achieve: Import dumps (objects+data) from multiple databases to local database ...
0
votes
1answer
37 views

Deadlock resource when try to drop datafile

This morning I did a mistake, I made a datafile offline by using alter tablespace users drop datafile 'C:\ORACLE\ORADATA\ORCL\DATAFILE\O1_MF_USERS_6LD56LRR_.DBF'; The reason is I want to drop that ...
-1
votes
0answers
27 views

While Recover Database and Database Open getting error ORA:01190

After Recover database from all OLD DBF File and run script for Alter Database Open resetlogs; Getting error message: ORA-01190: control file or data file 1 is from before the last RESETLOGS ...
0
votes
2answers
41 views

ASM Diskgroup Creation Issue

I have 6, two node RAC databases running in the two physical servers. While I try to create new diskgroup, I get the following error: ORA-15018: diskgroup cannot be created ORA-04031: unable to ...
0
votes
0answers
29 views

Is there any way to check database log about CRUD?

I want to test DB traffic simulating CRUD for my program. For this goal, the first, I want to know what actions(select, update, insert, or something) happen when my program is running with the DB so ...
0
votes
0answers
39 views

Unable to create new database in 12c RAC Mode with DBCA

I am new to DBA and currently trying to implement Oracle RAC cluster according to article -> RAC Deployment on AWS. I want to create a database which is non-CDB type on this architecture, although it ...
0
votes
1answer
45 views

Using Wildcard with `IN ('%')`?

Is it possible to modify the ('%') to return a single row for the following query, i.e. while keeping the entire statement before it? select 1 FROM DUAL WHERE TRIM('asdfsdf') in ('%')
3
votes
2answers
47 views

Why am I getting ORA-00937 error using only aggregate functions?

Here is a sample of what I'm trying to do: SELECT COUNT(T1.FIELD) + ( SELECT COUNT(T2.FIELD) FROM TABLE2 T2 ) FROM TABLE1 T1 I don't see a need for group by clause in ...
-1
votes
1answer
44 views

How to add default constraint in Oracle while altering column [closed]

I'm new in Oracle and my requirement is to port SQL Server statement to Oracle. I want to alter a column with adding a new constraint with a default value. SQL Server Query for the same: ALTER ...
0
votes
1answer
25 views

SQL Methods Function to add “Gold Medal” for anniversary

I'm trying to create a method function on SQL using Oracle Developer. The member function will give employees a gold medal after 12 years of service to the bank, a silver medal after 6 years of ...
0
votes
0answers
26 views

Oracle sql query add hours and sum results

I ask for your help with the following query in oracle whose function is to bring production speeds boxes. The AVANCEUM field is the real advance in boxes that tien and the theoretical speed is ...
-2
votes
0answers
23 views

oracle 11g express edition

I have installed Oracle 11g express edition (64 bit) in my windows 8.1 the installation completed but while running Im getting notification as the port 1521 tcp is blocked and Im unable to get through ...
-1
votes
1answer
38 views

Oracle csv line size more than 32767

How to generate csv in oracle if it's query result return more than 32767 character per line in linux shell script
0
votes
1answer
32 views

Oracle - Scan listener and multiple databases

I have a two node RAC database server hosting 8 databases. I have 3 scan listeners running. 2 in node 1 and one in the 2nd node. All the 8 databases are running for different applications. Are these ...
2
votes
2answers
215 views

Number of sessions connected to database

I need to know how many sessions was connected in a period of time for each snapshot. Is this possible in Oracle? Thanks
3
votes
2answers
44 views

Oracle “matches” multiple columns

I am developing a web service where a term of search is given, then I return all the matches from employees table. In MySQL I used to do the following: SELECT * FROM employees WHERE MATCH(name, ...
0
votes
0answers
51 views

Can't delete Oracle Datafiles after DROP TABLESPACE INCLUDING CONTENT AND DATAFILES

Just sharing this as a lesson learned... On Windows, when using DROP TABLESPACE INCLUDING CONTENT AND DATAFILES, the actual files on the harddrive don't get removed. Sometimes (not always) after a ...