Oracle is a RDBMS (Relational Database Management System) created by Oracle Corporation. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java. Also included is support for C (Pro*C, OCI and EXTPROC), C++ (OCCI) and Java (JDBC) ...

learn more… | top users | synonyms

0
votes
1answer
68 views

Stack trace of oracle sql execution

Is there a way to get the stack trace of the SQL query that is given in awr, I mean a way to check the flow of the query from which package or procedure that it has been triggered? tkprof and awr both ...
0
votes
0answers
40 views

In USER_INDEXES but not in USER_IND_COLUMNS

I can't believe I don't know this but what type of index (Oracle) would have an entry in the USER_INDEXES view and not in the USER_IND_COLUMNS view? I see two system entries in USER_INDEXES. Here is ...
3
votes
1answer
48 views

Migration From Oracle to PostgreSQL Encoding Errors

I'm working on migrating data from an oracle database to a postgresql database. I running into a problem where I export the data from oracle, using sql developer, and importing it into postgresql. ...
0
votes
0answers
35 views

Toad Error using Proxy Connection

I created a login for a user two days ago to an oracle database and altered another user so this new user could do a proxy connection as that user. Everything worked fine that day and the user was ...
0
votes
1answer
42 views

SQL select with unique_list - losing an item

I have an oracle database and I have the following problem: If I make an select like this: SELECT fk_proddes_id,fk_id_cod_deseu, LISTAGG (TO_CHAR (cod_eliminare), ',') WITHIN ...
1
vote
2answers
85 views

Compressing partition - what about index?

To save space on disk I want to compress some partitions of my tables: alter table TEST_TAB move partition TEST_TAB_2014 compress for all operations; I have also indexes on this partition. Should I ...
0
votes
1answer
37 views

oracle database - sql for counting the columns with the same id with the one in current row

I have an oracle database and a few tables and with this query: select rap.DENUMIRE,a3.ID,op.FK_ID, (SELECT COUNT(*) FROM ANEXA3_TABEL1_ROWS) AS count from ANEXA3_TABEL1_ROWS a3 inner join ...
0
votes
0answers
37 views

Oracle query optimization time

Is there any way to get how long it takes the optimizer to optimize a query in Oracle?
0
votes
2answers
36 views

how to prevent any update to my database before a exp operation?

I want to migrate my database from AIX to Red Hat vai exp/imp. how to prevent clients make any update to my database during the migration progress ?
0
votes
0answers
18 views

RMAN multilple channels

When to use multiple channels in RMAN? Is it effective only when backup is performed to multiple physical disks or tapes? I've found only that every channel is different session opened by RMAN in ...
-1
votes
1answer
39 views

Return Distinct Set of Values Based on MAX Date

I'm new to SQL and I am really struggling to put a specific query together. Let me start my question by explaining what fields & tables I am dealing with. Table A Table B The unique key is ...
0
votes
0answers
22 views

hierarchical query

I have a Oracle table that has child and parent rows similar to the example below P_JID has the parent's JID, it can go as far as 4 levels JID P_JID NAME STATUS ...
1
vote
1answer
39 views

Is there any way to trace the optimizer's work in Oracle?

Just like the MEMO structure in SQL Server which is kind of a "paper trail" of steps the optimizer takes in optimizing the query, is there anything in Oracle through which I can see what are the ...
6
votes
2answers
92 views

What is an Oracle ASSEMBLY?

What is an Oracle ASSEMBLY, in the context of Oracle SQL? It's listed in GV$SQLCOMMAND. Although GV$SQLCOMMAND is not a perfect guide to "real" SQL statements - for example it has UPSERT instead of ...
0
votes
1answer
44 views

Oracle copy DB from one windows server to another

I am not an Oracle DBA but looking for the best approach to copy/clone an Oracle database from one windows server to another, here is my configuration and my requirements: Configuration Server 1 ...
0
votes
1answer
73 views

What's the fastest way to migrate an Oracle database from Unix to Linux?

We have an Oracle database installed on AIX 7.1, and now we want to migrate our database instance to RedHat 6.2. The RedHat server has Oracle 11.2 installed already. What's the fastest way to ...
0
votes
1answer
43 views

Oracle can't drop index with . in name?

I am trying to drop an index that has a dot(.) in its name and can't seem to do it (I'm logged in as the SYSTEM user, which owns the index). Any ideas? SQL> select index_name,owner,status from ...
0
votes
0answers
35 views

Sql*PLUS: Output each field as a new line

Right now the configuration I have is the following: set pagesize 0; SET NULL *NULL*; SPOOL output/output.txt I am outputing the results to a text file in order to run a function on the file to ...
0
votes
1answer
196 views

How to restore 11gR2 fullbackup to 12c database in rman

I need to transfer my database from Oracle 11gR2 to 12c database. It will be in same computer. I took full backup of Oracle 11gR2 database. Then I remove Oracle 11gR2. I installed Oracle 12c and I ...
0
votes
0answers
35 views

Monitoring active query step using only pure sql

I would like to monitor actively running query on Oracle. What I mean is to gather info about: Actually running step. (What is currently db engine doing in this query) Actual query plan used in ...
0
votes
1answer
51 views

Select max value from many to many tables

i have next tables in may data base: I want to select the book that has the max number of pages for each author. I did this : select auteur.nomauteur, auteur.prenomauteur ,livre.Title, ...
0
votes
1answer
49 views

migration of oracle xe 10 to xe 11 fails with wrong paths used in the import

I'm following the documentation to upgrade an OracleXE 10.2 database to OracleXE 11.2. The export succeeded without any problem, the import (on another machine with XE 11) fails though. The log file ...
1
vote
0answers
88 views

How to identify concurrency issues in Oracle 11g?

For a short period in time we had a concurrency issue that lead to subsequent faults in our application (Java, Spring, Hibernate). Since we are using dictionary managed tablespaces, I first thought ...
0
votes
1answer
33 views

What is the query to get the process limit on Oracle 11g?

I'm getting the error: Maximum Number Of Process Exceeded I want to see (using a query) what the setting is in my database for the process limit. My question is: What is the query to get the ...
0
votes
1answer
186 views

Sql*Plus ERROR: ORA-12154: TNS:could not resolve the connect identifier specified

I installed Sql*PLUS on a cloud Oracle Linux Environment in order to access an remote database. I used the installation instructions provided as an answer here: ...
2
votes
0answers
25 views

what is causing the reads in this configuration?

i have a setup here where we use a Solaris 10 x86, zpool for oracle12c-redo-log using mirrored disks and mirrored ZIL. logbias="latency", recordsize=128: pool: xxxxxx01_redo00 state: ONLINE scan: ...
0
votes
1answer
36 views

Replace nested “select with count” with outer join? is this possible?

SELECT c.classid , c.classname , (select count(s.id) from students s where s.classid = c.classid and status = 'failed') as noOfFailed, (select count(s.id) from students s where ...
1
vote
0answers
32 views

SQL - Optimize table population with dynamic queries

I need to optimize the following pl/sql procedure. So, fundamentally my question is: There is a way you can do a bulk insert in a pl/sql that could be more efficient than loop through an associative ...
0
votes
2answers
55 views

Failed to connect to oracle SQL Plus [closed]

I tryed to connect to SQL Plus as the admin "System", I'm sure that the password I wrote was correct but the connection failed. I also tried to connect with Scott/tiger but it failed as well. What can ...
3
votes
0answers
56 views

Can an active session in oracle be dead?

I have a time consuming query which populates a materialized view. It has been running for 18 hours - which was not expected. SELECT STATUS FROM V$SESSION WHERE SID=194; The above query shows the ...
0
votes
1answer
72 views

What is the best query to get the latest row version based on time?

I'm wondering what can be the most efficient query to get the latest rows from the following table. CREATE TABLE AGE_DATA ( INSERTED_DAY TIMESTAMP(6), HOSTNAME VARCHAR2(255 CHAR), CONCEPT ...
0
votes
1answer
29 views

Oracle grant select on a table

I want to grant select permission on a specific table to a remote ip address I had done it before in Mysql with this: grant all privileges on mydb.* to myuser@localhost identified by 'mypasswd'; ...
0
votes
3answers
46 views

Oracle RMAN Back-up files in red hat can be read in windows?

We have performed a cold back-up of a database using Oracle RMAN. The back-up ran on a Red Hat Server and then the files were copied to a mounted external hard-drive. Can this back-up files then be ...
0
votes
0answers
18 views

Difference between @multitenant(SINGLE_TABLE) and @multitenant(VPD) in EclipseLink

Despite the fact I searched a lot in the internet and read many articles, I still be unable to get the difference between the Single_Table strategy and the VPD strategy of EclipseLink. At first I ...
0
votes
1answer
31 views

Using oracle hints

I am trying the following query to list the first 10 rows from fisgen table: SELECT /*+FIRST_ROWS(10)*/ salute, gender, fid FROM fisgen; The hint is not executed. All the rows from the table are ...
0
votes
0answers
17 views

Configuring management interface on Oracle RAC Listener

i have a SCAN configuration ready & working, but require along with it that each node be separately reachable on a management interface for administrative connections. Listener would have to be ...
2
votes
1answer
48 views

How do I retrieve the loop record in the connect by clause?

I have a employee-->Manager hierarchy and using the following query: SELECT EMP_ID, FIRST_NAME CONNECT_BY_ISCYCLE "CYCLE" FROM MYTABLE CONNECT by NOCYCLE PRIOR MANAGER_EMP_ID = EMP_ID START WITH ...
2
votes
1answer
71 views

With Clause vs View of the same name

In my database, there is a view named VAL_DATES_V which is used in many other views in the same schema. For example, the SQL code in the view SECTOR_V uses VAL_DATES_V. CREATE OR REPLACE VIEW ...
0
votes
2answers
27 views

Single select from template record oracle

Due to lack of terminology in my head, let's say I've got 1 record from users table with these attributes : Name | Surname | Height | Weight Person X 6,2 190 How do I find other ...
0
votes
1answer
44 views

Displaying output in SQLPlus [closed]

I will open my SQLPlus with CMD in windows. When I write a query it shows 157998 rows as result. I want see the all result in sqlpus window, but it is not showing all the result.
-2
votes
1answer
35 views

How to record sqlplus session activity like “/var/messages” in Unix..? [closed]

something like $ sqlplus '/as sysdba' @spool log1.txt SQL> --Is there anything like the above..?
0
votes
1answer
39 views

Oracle Text: query scoring with CTXCAT index?

If a text column is indexed with a CTXSYS.CONTEXT index it can return a score showing how well the text matches the query. create index ix on t(text) indextype is ctxsys.context parameters (''); ...
0
votes
1answer
80 views

Right way to restart Oracle 12c Server with pluggable databases

I am new to oracle. I installed Oracle 12c on windows with a pluggable database on a test VM. Everything was working fine. After the installation I was able to connect via EM Express on port 5500, via ...
0
votes
1answer
32 views

Regarding table access

How to revoke access for particular table from an user who have 'select any table' privilege? I want to block access to system tables that have password details such as user$ etc.. DB : Oracle ...
0
votes
1answer
64 views

Connecting to Oracle Pluggable database using service name

I installed Oracle 12c on windows using all the defaults but choosing to use a pluggable database and to install the sample data. The container database and SID name is ORCL and the pluggable database ...
0
votes
0answers
36 views

Is this MERGE statement correct?

Question: Is this MERGE statement correct ? emphasis on the ON and AND .. are they rightly placed? MERGE INTO VR_ORDER_LINE USING (SELECT * FROM E14) ON ( VR_LINE.RETAIL_NUMBER = ...
0
votes
1answer
103 views

Continuous replication between Oracle Database and Microsoft Azure SQL [closed]

Background info: Our core ERP has it's data on Oracle. Our own applications are Microsoft SQL based. Almost every application reads data from this Oracle database and usually there is some sort of ...
-2
votes
1answer
44 views

Single-row subquery returns more than one row

I try to run the follwoing query but it gives me 'Single-row subquery returns more than one row' error. BEGIN FOR C2 IN (SELECT S.bom_header, S.sap_cage_cd, ...
0
votes
1answer
281 views

Oracle 11g XE 64bits installation problem on Windows 7

I had to install Oracle 11g XE on my laptop under Windows 7. So I follow this Tutorial. The installation didn't even fail once, and seem to be OK. But every time i tried to connect to it with SQLPLUS, ...
0
votes
0answers
32 views

IO contention on raid5 happens?

I found all of the Oracle data files including redo, control, system, index and everything are in just one directory. And that directory is on Raid 5 disks. In this case do I need to do something ...