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
0answers
11 views

Oracle: Mutually modifying two tables?

Suppose I have two tables I want to keep in sync: create table a(x number, s varchar2(10)); create table b(x number, s varchar2(10)); It's easy to keep B synchronized with A, using triggers such ...
0
votes
0answers
13 views

column values combnation

I have chains of nodes like A -> B -> C -> F D -> E and store them in an Oracle table pair with 2 columns left_node and right_node left_node right_node A B B C ...
0
votes
1answer
14 views

Forgot to run END_UPGRADE during a Timezone File Upgrade (ORA-56924)

I ran the following to upgrade my timezone file from 4 to 14. The issue was after running the upgrade I forgot to run DBMS_DST.END_UPGRADE and put the DB back up and enabled incoming connections. ...
0
votes
0answers
15 views

Identifying high load sql

We had an oracle outage some days ago. We have inbetween awr tools. I genarated awrrpt report but dont see anything suspicious. Which report should I generate to see sql, which caused very high cpu ...
0
votes
0answers
24 views

Query on Sqlplus utility

I have a OS user 'test' who doesn't belong to dba group or oinstall group. I need to access the database using sqlplus but I'm unable to access the sqlplus even after setting oracle home ans path and ...
2
votes
0answers
14 views

Keeping version history / Slowly changing dimension

We're creating a new version of a 20 years old database, in which we used to keep version history by creating new rows in each table (SCD Type 2). SCD Type 2 is not that hard when you need to keep ...
-1
votes
1answer
27 views

Difference between exp and expdp [on hold]

I am a newcomer to database administration. Can someone briefly explain to me the difference between commands exp and expdp?
-5
votes
0answers
36 views

Running Oracle left outer join using (+) syntax on H2 database? [on hold]

Running JUnit test cases with an H2 database. The query I am testing uses Oracle 81 left outer join (+) sign. I have created all the tables in H2 database, but cannot run the query in H2 since it does ...
-3
votes
1answer
44 views

How does Oracle handle types in this UNION query? [on hold]

SELECT 1 FROM DUAL UNION SELECT '2' FROM DUAL; what does this give? knowing dual is default table and is a single row table.
0
votes
0answers
30 views

Identifying root cause of high cpu load

I need to research what caused a high load in our Oracle database some days ago. I wish to see a list of of high-load SQL statements. We don't use any Oracle tools like ADDM or AWR. I tried to ...
2
votes
1answer
34 views

Oracle and execution plans

I have used the following procedure to view the last execution plan create or replace procedure display_plan as begin for c in (select plan_table_output t from table(dbms_xplan.display_cursor('', ...
1
vote
0answers
20 views

Slow inserts in oracle 12c inmemory table

We are running some tests to check the in-memory performance on a 12c (12.1.0.2.4 EE) RAC. Servers have 56GB memory and 20core CPUs. Our plan is to have a few read-performance critical tables in ...
0
votes
1answer
44 views

Artificially increasing query time

Very weird question: Is there any way to artificially inflate the amount of time a query will take? An infinite loop would be great. SELECT CLAIM.UNIT_PRICE FROM CLAIM WHERE ...
0
votes
1answer
25 views

Oracle Golden Gate for Oracle 12c and SQL Server 2014

I have two server, server_1 with Oracle database 12c and a server_2 with SQL Server 2014.Both servers OS is Microsoft Windows. I want to implement data synchronization between them with Oracle Golden ...
1
vote
1answer
39 views

Estimating tablespace size

I'm trying to estimate the size of a tablespace using these steps: Space Estimations for Schema Objects and I was little confused about some of the steps. In step 3 for calculating the rowsize I ...
1
vote
1answer
23 views

Difference between OCCI and Instant Client package Oracle

I am a bit confused. I want to use Oracle Call Interface in C++ to interact with databases. This link: http://oradim.blogspot.co.uk/2009/07/getting-started-with-occi-windows.html says you need such ...
1
vote
0answers
29 views

Unable to get stable set of rows

I am trying to update latitude/longitude where missing using a merge statement. It errors: ORA-30926: unable to get a stable set of rows in the source tables. I thought that meant that the inner query ...
0
votes
1answer
23 views

Trouble understanding INITRANS in oracle

I need to calculate a tablespace size and part of the calculation requires a value for INITRANS which I don't fully understand and I wasn't sure if I should just use the default value 2. My business ...
0
votes
0answers
25 views

How to know imdp size?

I have a dump file using expdp with compression (oracle version >= 11g). Before running impdp I want to check if there is enough space on the machine but it seems as there is no parameter in the impdp ...
2
votes
1answer
28 views

Oracle: REGEXP_LIKE: Strings with angle brackets aren't found (whether they are escaped or not)

The following question will answer my original question, plus many others. What would the correct syntax be to do a REGEXP_LIKE search (in Oracle Database 12c) for this string (which exists somewhere ...
2
votes
1answer
35 views

Opening an Oracle database with a corrupted redo log

I have a database that is not open. And I have a redo log that is corrupted. What would be the best way for me to open the database? This is a testing db and I am not concerned with data loss - but I ...
0
votes
0answers
17 views

Does DB2 for z/OS have isolation level similar to READ ONLY in Oracle?

Does DB2 for z/OS have isolation level similar to READ ONLY in Oracle? I need to implement several big selects to DB2 and also I need to retrieve consistent data which was commited on time when ...
1
vote
0answers
33 views

Step by step connect to SQL Server 2014 from Oracle 12c and vice versa

I have installed Oracle 12c enterprise on my laptop with Windows 8.1 x64 os. I also have access to SQL Server 2014 through SSMS, that is located in another place and having so many transactions per ...
3
votes
1answer
73 views

Can a Table Lock eliminate a deadlock or make it worse Oracle

We have a situation in which an Oracle Database is having deadlocks issues. I said that perhaps we should lock into some table locks, and a guys response to me was "Unless I am misunderstanding ...
0
votes
1answer
51 views

How to install GLOBAL schema on Oracle 12c?

GLOBAL schema need to be installed for Oracle OLAP 12c. This link gives steps for installing GLOBAL schema on Oracle 11g and there is no page for Oracle 12c. ...
1
vote
1answer
24 views

Sync data in SQL Server 2014 with Oracle database12c

I have installed Oracle database 12c enterprise on my laptop. How can I implement data synchronization between Oracle 12c and SQL Server 2014 that whenever an INSERT,UPDATE,DELETE or ... happend on ...
0
votes
1answer
15 views

concurrent insertion in mutually exclusive tables in oracle

There are three tables: create table C(id_row integer primary key) create TABLE A(col_a1,col_a2,col_a3,..., id_row integer primary key, constraint fk_a_c foreign key (id_row) references C(id_row)) ...
0
votes
1answer
21 views

Run a script as a sheduled job using sql developer scheduler GUI

I have a script Alter Trigger TEST.LIVE_DELETE Disable; Alter Trigger TEST.LIVE_UPDATE Disable; ----------Running the comparison script---------------- var scanid number; SET SERVEROUTPUT ON ...
0
votes
3answers
27 views

I want a select to give me id's that are not in a consecutively order

I have an Oracle db with a table like this: +----+-------+ | ID | INDEX | +----+-------+ | 1 | 0 | | 1 | 1 | | 2 | 4 | | 2 | 5 | | 2 | 6 | | 3 | 0 | | 3 | 1 | | 3 ...
2
votes
3answers
69 views

Generate a list from columns that do not contain a zero for each row

I have a table TAB1 in an Oracle database: +----+----+----+----+----+----+ | ID | C1 | C2 | C3 | C4 | C5 | +----+----+----+----+----+----+ | 1 | 1 | 0 | 3 | 0 | 5 | | 2 | 11 | 22 | 0 | 44 | ...
0
votes
1answer
28 views

need to get data from Global Temp Table from db1 to db2 and show the data in Oracle form

I need to get data from Global Temp Table from oracle db1 to db2 and show the data in an Oracle form. In db1, a stored procedure is populating data in the GTT and showing it on Oracle forms as this ...
0
votes
1answer
26 views

Oracle: How to create secondary index based on every word in a CLOB

I have a Table where each record is made up of a VARCHAR2 and a CLOB. The VARCHAR2 is the primary key. There are currently 1.5 million records and growing. The table is only ever used for REGEX ...
0
votes
1answer
19 views

Loging queries and their error Text

I need to find out the statements that are unsuccessfully executed in sql, along with their error trace. As of now I created a trigger which is triggered on server error, which stores the sql text and ...
0
votes
1answer
24 views

Handling lossy data before character- set migration

I am trying to migrate a database from US7ASCII to AL32UTF8 using CSSCAN. During the initial scanning using CSSCAN we have found the presence of lossy data both in data dictionary() and application ...
0
votes
1answer
40 views

Oracle DB: Can one db file be shared between table space

Can one db file be shared between table space? I am deleting temp table space as below, Get all the files in table space: SELECT FILE_NAME FROM DBA_TEMP_FILES WHERE TABLESPACE_NAME = ...
3
votes
1answer
65 views

Oracle Audit: Why Logons are less than 0.1% of logoffs?

I see the following quantities of logins versus logoffs vs logoffs by cleanup in a database: SQL> select action_name, count(*) qty from Dba_audit_session group by action_name order by 1; 2 3 ...
0
votes
0answers
34 views

SPLIT PARTITION issue?

we had written program to ADD partition on every month. But, one of our customer forgotten to execute the program from Jan to July and now, he is facing performance issues (because corresponding table ...
2
votes
1answer
50 views

SQL query to identify missing hinted indexes

We have a fairly large number of queries using index hints in our 11.2.0.4 database. I recently uncovered some performance issues and found that some of the indexes referenced by the query hints were ...
2
votes
1answer
30 views

Oracle Application Express Listener PDF Report

We need our reports to be available in PDF format on our Oracle 11g, APEX:4.2.6 Followed this tutorial and selected "Oracle APEX Listener". But the generated PDF report is empty. We are using EPG. ...
0
votes
2answers
36 views

Database link from Local Oracle 11g to Oracle Database Cloud Service 11g

We are using Oracle database from Oracle Database Cloud Service, now we are not able to connect Cloud db from Local oracle db. Somehow we created link using below commnd, CREATE DATABASE LINK link_1 ...
0
votes
1answer
34 views

Can inserting new rows make the RDB not use an index?

Say I have a table with 10000 records. I then delete them and create them again. This is done with "normal" sql, row by row (not some sort of bulk insert (BCP in sqlserver lingua)). Does the ...
0
votes
2answers
35 views

Understanding RMAN Backupset

I feel a bit confused when I read about RMAN! what are the differences between: RMAN> backup as backupset RMAN> backup database; RMAN> backup database plus archivelog; RMAN> backup ...
1
vote
1answer
41 views

Merging adjacent date intervals into a single row

Here is the scenario: If the employee transaction is continuous display as-is. if the employee got any gap display as a new row. Below is the sample table Emid Fromdate Todate ----- -------- ...
0
votes
1answer
27 views

Why we can FLASHBACK DROP table where it is DDL command and hence autocommited?

DROP and TRUNCATE both are DDL commands and both are autocommited.Then why we can recover DROP table by using FLASHBACK(unless it is purge) and why we can not recover TRUNCATED data(don't consider ...
0
votes
0answers
41 views

Upsert - Should I verify the row exists first, attempt an update, or try to insert first?

In a software that I'm working, I have a table with a few columns and a id. In some events in my software, I need to update some column of a record with a certain unique field (other column), but ...
1
vote
3answers
69 views

Finding “islands” of holiday periods for employees

I'm looking for some tips to find a nice solution for my problem: Let's say I have a table, where days of vacation of employees are stored. e.g. CREATE TABLE test_dates ( id NUMBER ...
0
votes
0answers
31 views

Fetching the data from the Oracle database is slow in Linux as compared to Windows

I am facing a performance issue in Linux while fetching data from the Oracle database. My scenario is as follows: 1) I have the backend server which is on UNIX with Oracle database running . The ...
4
votes
1answer
59 views

Oracle Database 12c: Unable to resize system tablespace

Problem: My java application is returning ORA-01691: unable to extend lob segment errors for every insert Cause: After running: SELECT * FROM dba_tablespace_usage_metrics ORDER BY used_percent ...
4
votes
1answer
55 views

How to install olaptrain sample schema on oracle 12c?

I need to install the sample schema available from the Oracle website: http://download.oracle.com/otndocs/products/warehouse/olap/olaptrain_install.zip I am trying to run the commands as given ...
0
votes
2answers
42 views

RMAN 11g/12c Client compatibility

I'm having a Recovery catalog database 12c version. While I'm trying to register the target database (11g) with the catalog I get the following error: Recovery Manager: Release 12.1.0.2.0 - ...