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

4
votes
2answers
145 views

TNS-12541 Error

I have grid installed in my pc but the problem is LISTENER does not start automatically. I have to start listener manually and then only LISTENER get started. But before starting listener if you check ...
10
votes
3answers
562 views

Avoiding multiple `or` expressions

I have the following oracle SQL and its works and all but it's quite ugly with all of the ors. Is there a more concise way of doing this? SELECT * FROM foobar WHERE (SUBJECT ='STAT' and TERM ...
0
votes
1answer
106 views

How to set ADR Base directory correctly on OracleDB on Linux?

Installed Oracle Database on Linux based OS. Listener is ok. But Oracle is not. (I changed all angular brackets to vertical, because parser not shows angular brackets) ORA-48108: invalid value ...
0
votes
0answers
47 views

Oracle 12G Merge subpartition data into partition

I have a Oracle 12G table which is interval partitioned (monthly) and list sub-partitioned. There is no longer a requirement to sub-partition the table and hence I would like to "merge" the data in ...
1
vote
1answer
147 views

How to set the sequence to the last used id for all tables in Oracle?

I'm working on an open source elearning system called Moodle which usually uses MySql or Postgresql, but can also use MSSQL and Oracle. A client wishes to use Oracle, which I have limited experience ...
1
vote
2answers
80 views

Unable to describe table in oracle

I'm trying to get the description of a table in oracle because I need to know what foreign keys does it have and which tables they refer to. I'm using desc but all I get is "ORA-00900: invalid SQL ...
1
vote
2answers
56 views

Application testing: using multiple users in Oracle instead of mem H2. How to make it as fast as possible?

I decided to stop using H2 for obvious reasons (I have Oracle on production, compatibility mode is a fake). So, I wrote simple test framework which for each test in my application does the following: ...
0
votes
1answer
28 views

Update different oracle database from different oracle database

I want to update a CLOB column in B Oracle 11g database using a CLOB column in A Oracle 11g database located in a different server. What are the different ways to do that? and which is the best and ...
0
votes
1answer
59 views

ORA-08102 while creating a view

I am learning PL/SQL programming. I'm trying to create a view with the following statement: create or replace view viewName as select ID from employees; The view creation throws the following ...
0
votes
1answer
86 views

Difference between alert log and archive log in oracle databases

I don't know anything about oracle databases. Actually I'm asking this question for my friend (He currently doesn't have access to internet!). He wanted to know that what's the difference between ...
1
vote
2answers
113 views

Unexpectively slow data loading into Oracle

Big amount (4.000.000+) of files (1-4Mb each) are loading into Oracle 10g for about several days. Table is allocated in big tablespace, which was created on special volume (labeled BIG_VOL) over ...
1
vote
1answer
36 views

Graphical user interface to change data capture on Oracle [closed]

I'm learning how to implement change data capture in Oracle. However, not being a DB specialist but rather a developer, I find the process tedious with respect to other things that I have to do. I end ...
3
votes
2answers
50 views

Selecting minimum value in top grouping only

I have a query built in Oracle 10 which produces a set of data like this: EMP_ID WORK_DT TIME_TYPE ---------- --------- --------- 12345 19-DEC-14 10 12345 18-DEC-14 10 ...
1
vote
2answers
61 views

SQLPlus : default define settings

My workstation is Ubuntu 14.04. I have Oracle Express 11g installed. Whenever i run the define command in SQLPlus, is see the define _editor = "ed". Is there a way to change that permanently to gedit ...
1
vote
2answers
78 views

How to compare an Oracle database with a Postgresql database?

We are currently migrating an Oracle database 10gR2 to a Postgresql database 9.3. Thanks to Hibernate, all tables can be recreated seamlessly. However, the Oracle database is huge. We are going to ...
0
votes
1answer
48 views

How to unify three separate tables having same data, same columns but tuples in different languages. Only one key(caption) is common to all

This needs to be done in order to complete the unification of many tables present in different databases with different languages. (Part of Dictionary Management, will have caption and messages where ...
2
votes
1answer
156 views

Unable to connect to Oracle from SQL Developer

below is the error Status : Failure -Io exception: The Network Adapter could not establish the connection It's connecting from my system but unable to connect from other systems on the ...
0
votes
1answer
51 views

Oracle Golden Gate error 00146

I am deploying Oracle Golden Gate to sync data from Sql Server 2008 to Sql Server 2008. One of the extract process have stopped.This is the error: 2014-12-21 17:22:09 ERROR OGG-00146 Call to ...
0
votes
1answer
37 views

Need help in incrementing the date in oracle

Error thrown as "Invalid number" while trying to increment the date. Given below is the query executed through sqlplus. Please help me on this. select ''''||to_date(:To_date, 'dd-mon-yyyy')+1||'''' ...
0
votes
0answers
125 views

Oracle - Slow queries without prepending schema name or providing hint

I am logged in as the schema owner in Oracle 11gR2 on Linux. I have 55 million rows in table. select max(col) from table; - takes 300 seconds (index full scan) select max(col) from schema.table; - ...
1
vote
1answer
205 views

Can we migrate oracle database 10gR2 to cross platform

I want to know can we migrate Linux based oracle database 10gR2 (10.2.0.1.0) to windows server 2003 with oracle database 10gR2 (10.2.0.3.0). I have seen the documentation related to database migration ...
0
votes
1answer
66 views

Oracle SQL Statement alter index and add partition

I have an index in which I have to remove one column and reindex back for rebuild: ALTER INDEX <index_name> REBUILD; Is it possible to add partition when I rebuild an index. Partition will ...
0
votes
1answer
27 views

Enumerate Oracle tables in PLSQL

How do you run a query to list all tables, or all tables where tableName like '%abc%'. Just poking around, I tried the following with no success: select * from SYS.TAB$ select * from SYS.OBJ$ ...
0
votes
1answer
35 views

Need help in putting the single quote and constant timestamp in plsql

Please help me in appending the Single quotes and constant timestamp to my query output. Given below is the expected output from my param file. Note: Query is executed through sqlplus Expected ...
1
vote
0answers
76 views

ORA-01406 while building a Sphinx index

We are getting ORA-01406 error while trying to build an index over Oracle DB using Sphinx: root@bdt:~# ORACLE_HOME=/u01/app/oracle/product/11.2.0/xe/ NLS_LANG=AMERICAN_AMERICA.UTF8 indexer bsrpIndex ...
0
votes
1answer
666 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: ...
0
votes
0answers
73 views

How to compare between two values in one field depending on another field in SQL* / Oracle Reports?

I have three fields in a table named table_family. One is "relation" it has 3 kinds of values 1 for person, 2 for parents, 3 for son. Other field is "age" and it contains the ages of all the ...
0
votes
0answers
41 views

How to store values from a loop and compare them?

I have to select child items from a parent item and then compare text of each child and if the text is same I should not be displaying the heading. I have written a procedure for this, which is like ...
0
votes
0answers
53 views

ETL - Moving data from Postgres/Oracle to a TripleStore (RDF)

I'm looking for pointers on how to handle an ETL process that I have to implement for my organization. I know how to query SQL database but i'm not SQL DB specialist. I work more in the sphere of the ...
0
votes
2answers
178 views

Enterprise Manager cannot connect to 11g database instance

In Oracle 11g when we are opening OEM in browser it is showing the following message : "Enterprise Manager is not able to connect the database instance." Listener status is showing Up and Agent ...
0
votes
1answer
41 views

getting null result from table with data [closed]

So i have those two tables: DROP TABLE Ticket CASCADE CONSTRAINTS PURGE; DROP TABLE Store CASCADE CONSTRAINTS PURGE; DROP TABLE Employee CASCADE CONSTRAINTS PURGE; CREATE TABLE Employee ( emp_ID ...
-1
votes
3answers
119 views

Should tables with very large records quantities be split into multiple tables

I'm working on an application (asp.net) that deals with a very high record count -- let's estimate about 75 million events per year coming in fairly evenly throughout the year, and each of these ...
1
vote
1answer
74 views

How to access apex data from sqlplus?

I have setup an oracle database in my Ubuntu machine. Now I have took the following steps to create tables 1) login to my ubuntu account 2) su oracle 3) sqlplus "sys as sysdba" //Connected to an ...
1
vote
1answer
38 views

why when i run my sql code, the terminal stop on some wired number?

I am creating a trigger code is : CREATE TRIGGER TRIGGER01 AFTER INSERT ON WAREHOUSE REFERENCING NEW AS NEWWAREHOUSE FOR EACH ROW WHEN (NEWWAREHOUSE.STATE = 'MAINE') BEGIN INSERT INTO ...
0
votes
1answer
66 views

Change execution plan in Oracle

I have a large table called Table1 and another table Table2. A query is scehduled every day which inserts data into Table2 by selecting rows from Table2: INSERT INTO Table2(Cola,Colb,Colc..)SELECT ...
1
vote
2answers
131 views

ORA-00942 when trying to select from gv$session inside of procedure

I have been tasked with allowing developers to kill their own sessions in the Development database. I've written a procedure, but for some reason I'm getting PL/SQL: ORA-00942: table or view does not ...
0
votes
2answers
92 views

Oracle connection suddenly refused on windows 8

I am having all kinds of connection issues with sql developer all of a sudden. It was working till yesterday and stopped working on windows 8 machine. i am still able to connect via command prompt. ...
0
votes
0answers
22 views

Accounting - Dimention table in mysql

I am designing a accounting and mini erp system. I use a date dimension table to track all date related data. In oracle we can have many schema for a database. so we could create each schema for ...
0
votes
1answer
39 views

Create a new table oracle

Hello I recently changed companies and the databases as well. Having worked with postgres so far, oracle is still fuzzy to me, so here I am stuck with creating a table. This is my SQL attempt : ...
0
votes
1answer
74 views

Solaris 10 - Why shell limits needs to be increased to run oracle database?

Shell limits affect shell and scripts running shell like bash. Oracle's requirements (https://docs.oracle.com/cd/E11882_01/install.112/e48357/pre_install.htm#SSDBI1182 - section 2.10) is to modify ...
0
votes
0answers
41 views

Unique Constraint exception after dropping constraint

We had dropped a unique constraint using the ALTER TABLE DROP CONSTRAINT script, but it is still throwing the Unique Constraint exception while trying to insert. We drilled this down to two possible ...
-1
votes
1answer
288 views

Commit and rollback in Oracle stored procedure

In my Oracle stored procedure, I have multiple insert and update statements like below: create or replace PROCEDURE SPTest AS BEGIN insert into emptest(empid,empname,deptno) (1,'ravi',10); ...
0
votes
0answers
14 views

Oracle EBS 12 Installation Error : Usage ShelExec Document File

I am trying to install Oracle e-Business Suite r12 for windows 64-bit I have downloaded all files from oracle website (V46243-01) When I try to run ShelExec.exe I get this error message Usage: ...
1
vote
1answer
58 views

Extract from Oracle at given time

I have a requirement to retrieve (extract) data from an Oracle database (either 9i or 10g) as at a given point in time. I will need access to the data at this point of time for several days ...
0
votes
1answer
37 views

how to create user with less rights

I have created a sysdba user test_dba and then created database schema testdb. In that I created 50 tables. Now I need to create one more user "testdb1" for that schema with less rights . That can ...
0
votes
2answers
80 views

Different user can not access table

I have sysdba user and with that login I created a number of tables in db. After that I created one more user by login with sysdba. But this second user can not have access of tables that has been ...
0
votes
1answer
73 views

using update query with subquery in Oracle sql

I have an update query where I am trying to update a field but for more than one record, I am trying a join but it doesn't work. Below I get multiple values that come back from the select statement ...
0
votes
1answer
98 views

ORA-39244:Event to disable dropping null bit image header during relational select

I was trying to import a dump file using IMPDP command and has end up with the following errors: ORA-31626: job does not exist ORA-31637: cannot create job SYS_IMPORT_FULL_01 for user user1 ...
1
vote
1answer
60 views

Insufficient privilege

We are using oracle 11g I am replicating production db for dev environment. I Have a user named CST2 and CST0 where CST0 contains all tables and view and public synonyms for the same. I have provided ...
0
votes
3answers
144 views

How to tell from the OS whether Oracle instance is a standby, assuming no DB access?

One can easily check via SELECT database_role FROM v$database; whether your Oracle database is a primary or standby database. Is it possible to make the same determination without database access, ...