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
26 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
36 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; - ...
0
votes
0answers
68 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
0answers
5 views

Getting ORA-01031: Insufficient Privileges when logging in using Toad

I am having an issue when I attempt to login via Toad(version 11.6) to a newly create 12c database using the system account. When I enter my credentials and attempt to connect I receive the error ...
0
votes
0answers
19 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
17 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$ ...
-1
votes
0answers
35 views

Equivalent data types in Oracle database for SQL Server 2008’s uniqueidentifier and timestamp

I am working on SQL Server 2008 R2, and I have data types which is specific for SQL Server, including: UniqueIdentifier Timestamp Now I want to deploy my asp.net mvc 5 web application on an ...
0
votes
1answer
18 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
56 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
17 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
21 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
35 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 ...
1
vote
0answers
58 views

What is more important for Oracle DB performance, number of cores or memory size? [on hold]

Oracle has quite drastic licencing policy based on the number of cores. Can we save by providing a server with less cores, but more memory? Or is the number of cores the most crucial factor for the ...
0
votes
0answers
21 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 ...
-3
votes
0answers
17 views

ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file [closed]

Am getting this following error, ORA-01078: failure in processing system parameters LRM-00109: could not open parameter file Could anyone please help me out? Thanks in advance. GC
0
votes
2answers
58 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 ...
-1
votes
0answers
18 views

ORA-00937: not a single-group group function [closed]

select ITEM_NO,COUNT(distinct DBMS_LOB.SUBSTR(WM_CONCAT(ENVI_TEXT),1000,1))as COUNT_TEXT from TEXT where ITEM_NO in('40221354','70221357') and LANG_CODE = 'GB' group by ITEM_NO,ENVI_TEXT; I am only ...
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 ...
0
votes
1answer
22 views

Syntax error debugging [closed]

I have a logically sound insert statement, but always getting "integrity constraint (%s.%s) violated - parent key not found" and couldn't find why I get it. Everything seems alright to me, no typos. ...
-1
votes
3answers
72 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
24 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
45 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
35 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
37 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
16 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
32 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
37 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
32 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 ...
-2
votes
0answers
20 views

ORA-01779: cannot modify a column which maps to a non key-preserved table

SELECT ru.roleuser , opr.emplid ,ru.rolename ,ru.dynamic_sw , AU.AUDIT_OPRID ,to_char(au.audit_stamp , 'YYYY-MM-DD HH.MI.SS') FROM psoprdefn opr , psroleuser ru LEFT OUTER JOIN ...
-1
votes
1answer
44 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); ...
1
vote
1answer
41 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
35 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
58 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
37 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
39 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
56 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
76 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, ...
1
vote
1answer
38 views

Oracle performance loss from 10.1.0.2 to 10.2.0.5

I am testing an application on two database servers with the same data : 10.1.0.2 on Windows (for development) 10.2.0.5 on Solaris (for validation). We have a script which recreates a huge table ...
1
vote
0answers
27 views

Should an SCN obtained from one RAC node be immediately usable on other RAC nodes?

I'm seeing ORA-08181: specified number is not a valid system change number and don't understand why. The error happens around once a month from a process that runs every few minutes - so very rarely. ...
1
vote
1answer
31 views

How to format sql-plus-spool-file to *.csv with all columns in one line and row-content with linebreaks as one field?

I am not a professional, sorry. But perhaps you can help me anyway ... I have a table with 27 columns and within the rows data with linebreaks. When I try to export selected rows with sql-plus ...
0
votes
0answers
16 views

Required Information to start oracle warehouse builder

I am using windows 8 64 bit . I want to install Oracle Warehouse Builder on my system. I have installed Oracle 11g and come to know that Warehouse Builder is already a part of it. But when I start ...
0
votes
1answer
40 views

ORA-00942: table or view does not exist while creating synonym

We are using oracle 11g, the db structure goes like this: We have users CST and FAS. CST contains a table ST_CAT2, a public synonym ST_CAT has been created for the table CST.ST_CAT2 as a SYS user. ...
1
vote
0answers
38 views

Prevent row from being inserted with a trigger

I'm trying to prevent a row being inserted if a certain condition is met using a trigger. I'm using a user defined exception to do this, however the row is still being inserted, despite the exception ...
1
vote
3answers
161 views

How to handle big data update based on excel spreadsheet

Scenario Select-based data is exported from DB to Excel spreadsheets. Some manual work is done on the excel files (filling missing data). Changed data from excel files is updated back to DB. ...
1
vote
2answers
43 views

Will enabling row movements on list-partitioned table cause performance problems(oracle 11g r2)

Our incident management system has run for years, and the large quantity of closed incident tickets makes the table rather huge and slows down the search queries. Our database version is oracle 11g ...
0
votes
2answers
58 views

Oracle server 11g stops working with 12541 error until IP address changes

Running Oracle 11g 11.2.0.1.0 Server mysteriously stopped accepting connections to its databases. In other words, you run sqlplus and try connecting as any account and get an error that the listener ...
0
votes
1answer
62 views

Can not able to open / select table with another user in oracle

created a table with one user and cannot read or select the table after log in with another user. Database = Oracle Name : TestDatabase user name : sysadmin Another user created "user1" in same ...
0
votes
1answer
28 views

What are the OMem and 1Mem columns in the plan output?

The plan output, for example SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY_CURSOR( '' ,NULL,'ALLSTATS LAST')); has the columns OMem and 1Mem. What is their meaning? I could not find any reference or ...
1
vote
2answers
66 views

Linux kernel parameters for oracle

I wonder what are the optimal Linux kernel parameters for oracle 11g db on 64-bit system. I didn't find any detailed, good or full recommendations or best practices for this issue. Just found one ...