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
59 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 ...
0
votes
2answers
29 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 ...
2
votes
2answers
1k views

How to disable flashback query logging for a specific table (Oracle)?

We have a specific table that has a lot of activity and it creates a lot of change records. The consequence is that the flashback data only goes back a couple of days. That is OK for many cases but it ...
0
votes
1answer
132 views

How to update foreign keys in a large fact table using FORALL?

I have 2 tables, one is a fact table (100000000 records), and the other is a catalog (2000), I need to update the FK at the fact table, can I use FORALL in this case?. I wrote this but it doesn't ...
1
vote
2answers
22 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 ...
2
votes
1answer
28 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 ...
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
28 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
753 views

How to install ROracle on Linux

I am trying to install the ROracle library. This fails: install.packages("/storage/Downloads/ROracle_1.1-11.tar.gz", repos = NULL, type = "source") ** package ‘ROracle’ successfully unpacked and MD5 ...
0
votes
1answer
28 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 ...
1
vote
1answer
101 views

Type with nested table in oracle

I want to create a type with a nested table. I have a table called assignment_tbl which I want to put a type assignment_status. This assignment_status contains primitive types but also contains a ...
0
votes
2answers
13k views

Inserting data into a table with one value as clob and blob

My table has one clob column and one blob column. I need to insert data into it through insert statements. The length of data to be inserted is more than 4000 chars. When I do export of insert ...
3
votes
2answers
694 views

What is an Effective Way to Count the Number of Pages in Oracle?

We've implemented paging in our PL/SQL procedures by building a dynamic SQL query and then selection only a portion of results. We build implement paging by putting the original query inside a ...
0
votes
1answer
147 views

Keeping messages in a backup table after dequeue is completed

I would like to transfer the enqueued messages to a backup table after they have been dequeued. Currently we are using DBMS_AQ.DEQUEUE with mode dequeue_mode := DBMS_AQ.REMOVE. So after the message ...
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
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
42 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
2answers
2k views

Repopulating Oracle tables using data from Excel/CSV file

I'm developing a Java EE application that utilizes Hibernate/JPA. Some of the data I want to use comes from another Business unit's spreadsheet that I need to periodically (re)load into 5 Oracle ...
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
18 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
1answer
304 views

Can we take Backup on Disk and Tape at same time by RMAN? [on hold]

I'm trying to take backup by RMAN. I want to know can we take backup of database on disk and tape at same time by using RMAN? If yes then please share some documentation Or if no then please give the ...
0
votes
1answer
129 views

Import big CSV on Oracle

I have big CSV files and placed it on Linux (Amazon AMI). I have installed instant client on Amazon Linux AMI and I can connect to my Oracle database using SQL Plus. How can I import all the CSVs to ...
2
votes
2answers
3k views

“ORA-00942: table or view does not exist” when deleting from a very real table in the user's schema

I have a table that definitely exists in the logged-in user's schema (therefore I own the table) and is not a view/synonym/anything wacky. I can select from it, but when I try and either insert, ...
1
vote
2answers
4k views

Trouble setting up Nagios to monitor Oracle services

I've got an install of Nagios XI that doesn't seem to want to talk to any of my Oracle services here. I've pulled out the monitoring command and am running it manually, after setting ORACLE_HOME and ...
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
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
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 ...
2
votes
1answer
46 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 ...
0
votes
1answer
4k views

JDBC pooling Oracle driver Socket read timed out

I run Java EE application on Glassfish server v3 together with Oracle 12 DB on the same machine under Windows Server 2012 64bit. I use latest ojdbc7 driver. Connection pool config: ...
1
vote
1answer
20 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 ...
1
vote
1answer
240 views

Not able to update MySQL table using Oracle: Unknown column in 'where clause' {42S22,NativeErr = 1054}

I have the following tables: MySQL table: jti_member_interact CREATE TABLE `jti_member_interact` ( `INT_MEMBER_ID` int(11) NOT NULL, `INT_ID` int(11) NOT NULL AUTO_INCREMENT, `INT_SOURCE` ...
0
votes
3answers
178 views

Replacing the results of a row

I'm working with Microsoft Reporting Services 2008. In our database, we have a small group of confidential students that need to be taken into account for several queries. If they are a confidential ...
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
1
vote
1answer
78 views

Startup oracle database 12c manually with SQL*Plus command not when OS loads

I changed oracle instance to manually start from services.msc (service name is "OracleServiceORCL"), Because I want to start it up manually with SQL*Plus commands whenever I want, not with OS load. ...
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
48 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 ...
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 ...
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 ...
1
vote
2answers
5k views

ORA-02049 and ORA-02063 Errors

Select For UPDATE NOWAIT is performed on a table by 20 processes in parallel The error below is returned by the 4 processes out of 20 (16 processes are successful) SQL_UPDATE_ERROR- : SQL update ...
0
votes
2answers
710 views

Error in trigger: table X is mutating, trigger/function may not see it

Having looked at the following Trigger, still getting the Row 2 error: "ORA-04091: table SUMMITTEST.APL_LOG is mutating, trigger/function may not see it" Please can anyone provide any help in ...
1
vote
0answers
56 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
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 ...
3
votes
1answer
3k views

Oracle 12c SYSTEM user locked out

We have a development Oracle 12c database and the SYSTEM user account is locked out for one of the SID's (works fine with another SID). When I try to do a conn SID / as sysdba it keeps connecting me ...
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
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: ...
-2
votes
1answer
31 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?
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. ...
1
vote
2answers
6k views

Create Oracle DB LINK to a database with no DB_DOMAIN

I'm trying to create a database link between this two DBs. My local DB is 11.2.0.3. SQL> select * from global_name; GLOBAL_NAME ...