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

Explain plan shows a table not in the query

In trying to optimize a 2 minute query against an SAP R3 Oracle database, I examined the Explain Plan in Toad and found that most of the query's time is spent on a table that isn't even in the query. ...
0
votes
1answer
61 views

Insert Into does not work with multiple rows

Here Is my code : CREATE OR REPLACE TRIGGER LOAN_RP AFTER INSERT OR UPDATE ON FUND_DISBURSE REFERENCING NEW AS NEW OLD AS OLD DECLARE V_FA FUND_DISBURSE.FUND_AMT%TYPE; V_RC NUMBER ...
0
votes
1answer
376 views

Oracle error: UDI-00018: Data Pump client is incompatible with database version 11.01.00.06.00

I'm trying to use data pump to move the database to a different server with this command: impdp dbuser/dbpsw@dbserver directory=data_pump_dir network_link=sourceDB schemas=EMP But I got this error: ...
2
votes
2answers
53 views

Oracle Data Pump Import imports no records

When we do an Oracle Data Pump import of our database, it runs without significant errors. However, on one table Oracle reports that 0 records have been imported. Processing object type ...
0
votes
1answer
126 views

FAST REFRESH ON COMMIT on Materialized view

I am trying to implement a materialized view which would Fast refresh on commit. I have created materialized view logs on base table as well but i am faced with the following error. ORA-12052: cannot ...
0
votes
0answers
38 views

How to import data into Oracle 11g r2 daily

I need to batch load several log data files (comma delimited but they don't have a .csv extension in the file name) once each day into an Oracle database. I'm sure this is a very common use case, but ...
0
votes
1answer
119 views

Generic or better yet custom message of the day in Oracle sql plus

I'm trying to create a message of the day type notification when users login to sqlplus. Currently I use the login.sql to add a dbms_application_info and set a module and action for the message. ...
0
votes
0answers
23 views

Oracle 11g Enterprise Manager failing after backup restore on new host

I'm doing disaster recovery scenario on Windows Server using full cold backups made with EM. My actions are following: Install Oracle 11g SE on new host with creation of db with same path and name. ...
0
votes
0answers
26 views

My Query is waiting on “db file sequential read” for 5 minutes and getting timeout after that in Oracle

I have a very simple query when I run it individually from the SQL developer in my oracle database it is running perfectly, but when it is part of application flow then it is failing with timeout and ...
0
votes
2answers
65 views

What is the easiest and best way to migrate data from Oracle in Linux Platform to SQL Server in Windows Platform?

I came to know there is a tool called Microsoft SQL Server Migration Assistant v5.3 for Oracle which can be used to convert the Oracle database to Microsoft SQL. But I have Oracle database in Linux ...
0
votes
0answers
31 views

How to find materialized view log dependencies over database links

Is there a way to identify materialized views that have used a given MV log, even if the MV is using the log over database link? (Oracle EE 11.2) The problem is that I would like to drop a certain MV ...
2
votes
2answers
451 views

FileWatcher Troubleshooting Options

I have setup a Credential/Procedure/Program/File Watcher/Job to monitor a folder for new files, but it is not working. I am trying to figure out what I can check to troubleshoot why this isn't ...
0
votes
0answers
68 views

notification email when deadlock is encountered in alert log,oracle

how to send a notification email when deadlock is encountered in alert log on any node like the deadlocks encounterd below (an alert any time a deadlock is detected in alert log.) Node 1: Mon Sep ...
1
vote
1answer
124 views

Reoganize Objects in OEM - Host Credentials do not have enough privileges

When I try to re-organize objects from OEM (11g) and enter my host credentials (not "oracle"), I get the message: "An error occurred verifying the host credentials. Make sure the credentials are ...
0
votes
2answers
6k views

How to move csv file into oracle database using sql developer?

How to move csv file into oracle database without creating table firstly using sql developer rather than sql loader?
0
votes
2answers
2k views

Oracle query is slower the second time

I have a general question about something I'm seeing in performance tuning in Oracle. I have a query that I'm testing. It's too big and complex for me to provide a simple example, sorry! (I tried ...
0
votes
0answers
12 views

Oracle Counters for Windows Performance Monitor exceeding handle quota

On several windows 2008 R2 servers with an oracle 11.2.0.3.0 database installation i see the following warning in the eventlog every couple of days: Windows Management Instrumentation has stopped ...
0
votes
2answers
47 views

Oracle service_name vs database name

I am reading about Oracle and I am confused with the two names: service_name and database name. Do they both refer to the database name used while creating a database with the CREATE DATABASE xxxxxx ...
0
votes
0answers
186 views

ClassNotFoundException when trying to deconfig Oracle Enterprise Manager

The Enterprise Manager for my Oracle 11.2 installation doesn't work anymore as described in How can I change the connection descriptor used by Oracle Enterprise Manager? and I tried to re-configure it ...
1
vote
1answer
91 views

How to export a MySQLtable with a longBLOB column to an Oracle database?

In MySQL I have a table: Select * from Dummy; Columns like below: id name salary binary_col 1 a 100 A.pdf 2 b 200 b.pdf 3 c 300 c.pdf 4 d 400 d.pdf 5 e 500 e.pdf ...
0
votes
1answer
60 views

Mutiple updates with 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 for all in this case?. I wrote this but it doesn't ...
0
votes
2answers
1k views

SQL Server to Oracle export using Microsoft OLEDB Provider for Oracle

I am trying to Export Data from SQL Server to Oracle using the "Microsoft OLEDB Provider for Oracle". I am using "Export Data..." option from Task menu. I get to connect to the source database (SQL ...
0
votes
1answer
78 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
2answers
550 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 ...
2
votes
1answer
122 views

Database design for a table with both bulk insert and single row insert

I have to design a table where records will be inserted in two ways. Bulk insert from a batch process from a delimited text file between 2 - 3 million rows in a short burst. Later the same records ...
0
votes
2answers
1k views

ORA-12154: TNS:could not resolve the connect identifier specified

I've initially posted this question on serverfault.com, but because lack of answers decided to post it here... I'm trying to use bat file/CLI to run SQL script against certain Oracle database with ...
0
votes
0answers
11 views

ORDB whats the use of “add scope”

I'm newbie to ordb. In a oracle tutorial I found this. What is the use of this. And where should we use this add scope. I thought its a referential constraint. add scope for (company) is stock
0
votes
3answers
62 views

comparing values between two tables

how to Compare values between two different tables I have two tables as shown below Table 'A' sql_id OPERATION OPTIONS 63kf3an2j0pk SELECT STATEMENT 63kf3an2j0pkc TABLE ACCESS FULL ...
4
votes
1answer
521 views

Ports necessary for Oracle 11g Replication across a firewall?

We have two Oracle 11g Enterprise Edition servers that need to replicate data via Oracle streams. However, the two servers are on untrusted domains and connect via a VPN. On end of the connection is ...
3
votes
1answer
66 views

How can I prevent having inconsistent data under isolation level serializable in Oracle SQL?

I have the following table: InStores +--------+---------+-----+ | ProdID | StoreID | qty | +--------+---------+-----+ | p1 | s1 | 25 | | p1 | s2 | 70 | +--------+---------+-----+ ...
0
votes
2answers
109 views

Make Oracle backup files available for duplicate

I have a Red Hat Enterprise Linux server with Oracle 10.2.0.5 and a database on it (SID is TNATEST). I have a remote CentOS server with Oracle 10.2.0.5 on it that I want to duplicate TNATEST to. The ...
0
votes
0answers
37 views

Debug network latency when getting data from oracle

I have an application which needs to connect to Oracle database to bring my instance up. Oracle server is running on U.S server, While I am accessing it from India Sadly it takes an hour to get ...
1
vote
2answers
2k 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
2answers
50 views

Oracle GROUP BY question

I am using Oracle8i Enterprise Edition Release 8.1.7.4.0 - Production. Yes an ancient version but the license is embedded in an application that we use and this is the Oracle version that they use. ...
0
votes
1answer
244 views

Wallet open failed

I have a oracle server installed in a machine and e oracle client on another machine. I have created a wallet using this commands C:\Users\MRBULL93>mkstore -wrl C:\VideoWallet -create ...
2
votes
0answers
45 views

Master and Read Only Oracle Database synch is unacceptable [closed]

Not a DBA, I am a developer, currently my team uses a Database set up created by the DBAs which we have little control over. All write's go to a master and then from there it is synched out to read ...
0
votes
2answers
33 views

inconsistent type after querying search_condition column in all_constraints table Oracle

I'm trying to get the not null constraints in my tables, so I'm using the following sql request : select * from all_constraints where owner='userx' and constraint_type='C' and ...
0
votes
1answer
60 views

Modify text file with Oracle PL/SQL

I'm trying to open and replace a string in a text file with the following procedure: BEGIN v_file_name := 'text_file.txt'; v_filehandle := utl_file.fopen(v_file_dir, v_file_name, 'W'); v_id_nextval ...
9
votes
4answers
9k views

Cannot drop nonexistent constraint and cannot create it either

While testing some migration scripts with a copy of production data (scripts run fine with development data) I found a curious situation. A CONSTRAINT has changed so I'm issuing DROP + ADD commands: ...
-2
votes
0answers
32 views

Midnight Datetime difference - SQL Oracle

We have an application which reads information from SQL and Oracle (testing purposes). A datetime value is placed inside the table: Example: 05/09/2014 00:00:00 When we have this date in SQL: The ...
0
votes
0answers
28 views

Is it possible to get this output in Oracle 8i?

I am using Oracle 8i. I have a table Ord that stores data on such, with two columns that I'm interested in OrdNum and OrdDate. Here is an example SELECT OrdNum, OrdDat FROM Ord; OrdNum OrdDate ...
0
votes
1answer
668 views

Stored Procedure result is not showing in Datagrid pane in Toad for Oracle

Hi I have created a procedure in Toad for Oracle 12. When I execute the procedure it does not show the dataset in datagrid pane. While procedure get executed successfully. What I am doing wrong. ...
3
votes
1answer
2k views

Why ORA-00932: Inconsistent Types error?

Sorry for the meaningless title, but I couldn't think up a better one. I'm using Oracle 11g r2. The following query raise ORA-00932 error: SELECT BBB.FIELD1 FROM TABLE0 AAA JOIN (SELECT * FROM ...
0
votes
1answer
32 views

Connect Oracle database using AD account via OID

We have configured Oracle Internet Directory. We have integrated OID with AD. We have also registered Oracle database with OID. And we are now trying to configure authentication to the database with ...
2
votes
1answer
73 views

Select the max from two max values

I need to find the airport(departure or arrival) that had the most passengers in the last year. The tables are: PASSENGER(id,name,surname) TAKES(id_passenger,id_flight) ...
0
votes
2answers
38 views

Filtering of sql output

I want to migrate the database. When I disable the constraints before adding the data to the output file I get extra lines: SQL> spool disable_constraints.sql; SQL> select 'alter table ...
0
votes
1answer
398 views

sqlplus is not starting

I have a strange error on a Red Hat machine. InstantClient is installed in and ORACLE_HOME is set to /opt/oracle/product/112030_cl_64/cl/ The user which installed the client was oracle:oinstall. My ...
0
votes
1answer
29 views

Choosing the Most Recently Entered Non-Blank Value When Many Values Exist

I have run into a problem where some IDs have multiple names associated with them. That is, if I have a location ID from one table and need to pull the location's name from another table based on the ...
3
votes
1answer
258 views

Security for Oracle linked server from SQL Server

I'm trying to make the linked server from SQL Server 2005 to Oracle more secure by not having user/pass on "Be made using this security context:" fields so only a specific user can access the data ...
0
votes
0answers
38 views

PL/SQL Error bad bind variable

Where is the problem with my code. It should work, but Compiler says: Error(5,14): PLS-00049: bad bind variable 'NEW.NAZWA_GRUPY' Error(6,1): PLS-00049: bad bind variable 'NEW.NAZWA_GRUPY' ...