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

2
votes
1answer
32 views

Why is Oracle's dbms_metadata.get_ddl returning different results?

I'm trying to compare two schemas using dbms_metadata.get_ddl. The two schemas were created using exactly the same SQL scripts. However on one primary key I'm getting a difference in the DDLs: ALTER ...
1
vote
2answers
23 views

Oracle RAC VIP issue

I have a two node RAC setup where my scan ips are registered in DNS and my public Ips are also registered in the dns. Now while connecting from my windows machine through oracle client in sql ...
0
votes
0answers
9 views

Oracle 12c 2-node RAC, after first reboot CRS is hanging/stuck on octssd on the second node

My issue is with the Cluster Time Sync Service on the second node of an Oracle 12c RAC 2-node cluster on Oracle Linux. After the first reboot the second node is stuck on the octssd.bin process. I ...
-2
votes
0answers
29 views

How to make a procedure Loops on all Rows [on hold]

Hey there i have created a table as in the attachments ... and i have created a procedure that works on a specified columns of the table to serve this purpose: update score depend on random number R ...
0
votes
1answer
29 views

How to prevent insert row duplicate value in a column and equal the any value

I have table TABLE1( id number (primary key), IDAccount number, status char(10)) Table can have 2 row duplicate (IDAccount, status) with status=disable as well as id IDAccount status 1 ...
0
votes
1answer
30 views

How do I copy a materialized view to a table?

I have a materialized view. I want to create a copy of it so I can modify some of the data to test a few theories about an issue and its possible solutions. How do I make a copy of this MV as a ...
0
votes
1answer
43 views

Update if exist in other table

I want to update column in table A if the value of column A1 exist in one column of B table for example B2 update A set A1 = 'F' WHERE A1 in (SELECT B2 FROM B ); I tried somethig like this but no ...
0
votes
1answer
36 views

Alter user - is password stored in audit trails

I was asked an interesting question the other day and I have not been able to find a definitive answer. If one of my DBA's changes a password, will the password the password show up in plain text in ...
1
vote
1answer
26 views

Move PDB to a new host

We're using Oracle 12c, and have two separate servers running Oracle, with a CDB with 2 PDBs. What is the easiest way of getting the data from server A to server B, as a one-time job (not ...
1
vote
1answer
22 views

How to drop java source from Oracle properly?

I'm a little stuck here with my Java Source. First I want completly drop it from the database, because I want to recompile it, but I can't drop is, because if I execute this command: drop java ...
0
votes
0answers
12 views

Special characters encoding data flow SAP Data Services

I have been struggling with the configuration of a new oracle datastore, my problem is related with encoding : I have added my database definition to tnsnames.ora file on the job server (redhat ...
0
votes
1answer
62 views

avg sale of quarter with previous quarter avg sale

I have a table one in which there are various attribute like region product,year,qtr,month,sale. I have to calculate the avg_qtr sale of each product having same region and show their previous avg_qtr ...
1
vote
1answer
21 views

Question on Oracle OEM version and plugin version upgrade

I have a OEM 12c (12.1.0.4) running in my setup in which I have registered over 70-80 databases. I see the plugin updates with versions of each target (Oracle database, MS-SQL, MySQL) and I have the ...
1
vote
1answer
27 views

RMAN archives deletion

I have a file system for my archives which gets full in a short span of time. I want RMAN to backup all the archives automatically and delete the archives after backing it up when the archives ...
0
votes
1answer
37 views

ORA-01031: insufficient privileges

why do i get ORA-01031: insufficient privileges ? SQL> grant create view to rojib; Error : grant create view to rojib * ERROR at line 1: ORA-01031: insufficient privileges
0
votes
0answers
9 views

Connection between SQL Server 2014 and Oracle 12c [duplicate]

I have to server: 1.Server_A with Oracle 12c 2.Server_B with SQL Server 2014 I want these servers see each other, though I can SELECT anything I want in Server_A from Server_B and vice versa. I ...
0
votes
1answer
24 views

Query on Standby redo logs - Oracle

I have a oracle 11g (11.3) database running with two standby databases (at different locations) in Maximum performance mode. The platform is Linux. Log transport parameters are: log_archive_dest_5 ...
2
votes
1answer
47 views

DBMS_METADATA.GET_DDL not displaying complete DDL for big tables

While generating the DDL for a schema, big tables' DDL are getting truncated. After displaying close to 110 rows I am getting an ellipsis (...). I am using SQL developer to run: SELECT ...
1
vote
0answers
58 views

Oracle DBA Daily/Weekly/Monthly or Quarterly Routine Checklist/Tasks [closed]

Recently I'v achieved Oracle Database 11g Administrator Certified Associate (OCA) after passing two exams (1Z0-051 & 1Z0-052), then I got a Job as an Oracle DBA in startup company. So, I would ...
0
votes
2answers
53 views

ORA-01830: date format picture ends before converting entire input string

I am trying to run the query on an Oracle database select to_date(trunc(sysdate) || '13:00:00','DD-MON-YY HH24:MI:SS') from dual; and get the error ORA-01830: date format picture ends ...
0
votes
0answers
25 views

Calculating table size

I'm trying to follow these steps: Space estimation to estimate the size of my table that I'm creating. I specified an INITIAL as 1M and using the steps above I have the following estimations: ...
1
vote
1answer
34 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
35 views

column values combination

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
36 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
26 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
33 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
20 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 ...
-2
votes
1answer
32 views

Difference between exp and expdp [closed]

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

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

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
48 views

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

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
1answer
49 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
41 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('', ...
2
votes
1answer
39 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
47 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
46 views

BI-DIRECTIONAL Oracle Golden Gate for Oracle 12c and SQL Server 2014

I have two servers (both servers are on Windows OS): Server_A running Oracle 12c Server_B running SQL Server 2014 I want to implement data synchronization between them with Oracle Golden Gate ...
1
vote
1answer
52 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
25 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
32 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
27 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
28 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
38 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
38 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
58 views

Step by step establish a connection between SQL Server 2014 and Oracle 12c

I have two servers (both servers are on Windows OS): Server_A running Oracle 12c Server_B running SQL Server 2014 I want these servers to be able to see each other, so I can SELECT anything I want ...
3
votes
1answer
74 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
58 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
30 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
25 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
28 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 ...