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

1
vote
0answers
9 views

Listener.ora problem when I copy OVA

I deployed a new VM Oracle machine using a copy of my existing Oracle VM. As a result, the new VM inherited the same host name. This is redhat linux 6.5, Oracle11g. I changed hostname everywhere as ...
1
vote
1answer
17 views

Moving a date between tables is causing error ORA-01841 [on hold]

Here's my script: INSERT INTO BRAND_RECORD SELECT STRENGTH, GENERIC_NAME, TO_DATE(a1.FIRST_CLAIM_DATE) as INTERCHANGEABILITY_DATE FROM DRUG_INFO INNER JOIN ( SELECT ...
1
vote
0answers
16 views

Repeating rows of date intervals based on another table in Oracle

I have a table of maintenance plans with date intervals between each required maintenance period. Fiddle: http://sqlfiddle.com/#!4/af742 create table maint_sched (maint_id number, start_date date, ...
1
vote
1answer
37 views

Tune Performance by putting large tables into the KEEP Pool

We currently have a database with 20GB SGA space. SQL has been optimized but has to statisfy its use cases as well and some queries are very, very slow, specifically when large result sets are ...
-1
votes
0answers
25 views

Getting error ORA-01034: ORACLE not available [on hold]

I am getting this error while connecting my database in oracle sql developer. ORA-01034: ORACLE not available. ORA-27101:Shared memory Linux Error:2:No such file or directoy
0
votes
0answers
16 views

Can we Audit Synonym Usage in Oracle?

When Auditing is enabled in Oracle, is there a way to differentiate Private Synonyms access from actual object access? For example If I have Table: S1.My_TABLE Private Synonym: S2.My_TABLE ...
0
votes
0answers
24 views

Maxing out the shared pool's memory by executing many UPDATE statements (ORA-04031)

I was executing a bunch of UPDATE statement. Around ~32.8K got executed and committed, then got the error: cx_Oracle.DatabaseError: ORA-04031: unable to allocate 3896 bytes of shared memory ...
-2
votes
1answer
30 views

ODBC Problem ORA-1089 cause ORA-3114 [on hold]

I have a program (I don't manage the code) that uses an ODBC connection to send data to an ORACLE 11G database. Everething works fine but when the DBA uses the command SHUTDOWN INMEDIATE, the ...
1
vote
1answer
33 views

2 Different Oracle DB Version on same server

Is it possible to install and run 2 different oracle version(11g and 12c)software and db on same server? is it possible then how we can? and if not then why? Thanks Rahul Joshi
0
votes
3answers
32 views

TNSNAMES.ORA is located in Windows 2012 Server

Can you please any one help me for the following TNSNAMES.ORA is located in Windows 2012 Server? Can you please give the correct path for the same.
-1
votes
0answers
18 views

How to use Oracle developer sql query in php? [on hold]

I have following query on Oracle developer. How do i convert it to be used in php? I have never used so complex queries with Mysql. My Wamp is configured to contact oracle db, but i have no idea how ...
2
votes
1answer
35 views

Is there any point in specifying the precision and scale of a number for a foreign key?

I am running Oracle 11gR2 11.2.0.3. I have two tables: table1 contains a column named SUBJECT_ID, whose datatype is NUMBER(7,0) (numbers range from 13 to 48480) table2 contains a a column named ...
1
vote
1answer
34 views

Query with group by having count 0

I am working on application for managing football league as my homework. I want filter list of players by number of matches they have played in league. For example user can enter count > 0 and count ...
0
votes
0answers
46 views

Oracle RAC takes forever dropping tables

We are seeing table drops consistently take tens of seconds on our Oracle 12c RAC. It appears to be spending on its time on reliable message waits. Which I think means that it asks the other node to ...
1
vote
1answer
76 views
+100

RMAN backup is stuck/taking a long time

I am trying to run an RMAN backup that is either hung or is taking a very long time. Some background: I inherited this database, and I am unfamiliar with Oracle, as I am an SQL Server guy, so please ...
0
votes
2answers
80 views

Get list of students having actions in Oracle

I have a table of student actions (id, student_id, type, and quarter). I need to get a list of all the students, along w/ a flag of whether they had a particular action in the current quarter, and the ...
1
vote
1answer
41 views

How to determine how much storage space a column takes in Oracle?

How to determine how much storage space on the disk a column takes in a table in Oracle? I'm running Oracle 11gR2 11.2.0.3.
0
votes
1answer
34 views

how to extract an integer from a column having an xml of clob data type?

Hi Please help me with this. I have a column name X_XML_STR and it contains an xml but the xml is stored in the table with type CLOB. I want to extract an integer from it. How can this be done? Here ...
0
votes
1answer
25 views

Standby database between Oracle Enterprise and Oracle Standard [closed]

Is it possible to organize Standby Database between different Oracle editions - Enterprise (as primary) and Standard (as Standby) ? and i know about DataGuard - we can create Standby mode manual. and ...
1
vote
1answer
32 views

Provides Oracle's database in-memory?

I'm trying to find out, if Oracle's newest database release 12c comes per default as an in-memory database or does it use TimesTen for this feature? According to Wikipedia (Oracle Database) it ...
0
votes
1answer
51 views

How to add a column from another table?

I'm starting to using SQL statements in my Oracle database XE (tables and relations made by me) and I'm having a hard time to understand how can I put a column from another table. The example in ...
0
votes
1answer
33 views

How to create oracle user for more than one version

I have server under RHEL 6.3 installed on that server Oracle 11gr2 and 12c, I want to create user lets say Ahmad but I want this user to be sysdba on both servers, for single server I edit ...
1
vote
2answers
38 views

Oracle 11g encrypt traffic from clients to database server

I have Oracle 11gR2 db at my work. Last week security team informs that we need to encrypt all the traffic for database users to our databases. First thing that I have checked was Oracle solution - ...
-1
votes
0answers
53 views

SELECT FROM OTHER TABLE WITH TWO SAME COLUMNS [closed]

I have problemm with sql SELECT Emp Table | ID_E | NAME | ------------- | 1 | JAMES| Countries Table | ID_E | COUNTRY | ---------------- | 1 | USA | | 1 | UK | select p.id, ...
0
votes
2answers
33 views

Is using ASM a pre-requisite for RAC?

I am about to build our first RAC development environment, and as I'm new to RAC and have not used ASM I wanted to keep things as simple as possible. I was under the impression that ASM is a ...
-1
votes
1answer
58 views

Switching from Oracle database to Ubuntu [closed]

I need support please. I am the CEO of a Life Assurance company. We are currently building our own core application under the leadership of my Head of ISD. We are using Oracle for our database and ...
1
vote
1answer
46 views

Database design/structure for address details [closed]

I am trying to design database. I have one problem related to addresses. The will be different types which will have addresses, for example Companies, Persons. I am not sure how to design my database. ...
-5
votes
1answer
31 views

How to execute stored procedure in another procedure in oracle [closed]

Is it possible to execute stored procedure in another stored procedure in oracle both are in same db. And also if any procedure not executed then other procedures to rollback.
1
vote
1answer
30 views

What problems would using the reserved keywords DATE and TIME as column names cause in Oracle?

DATE is an SQL Reserved Word and TIME is a PL/SQL Reserved Word in Oracle (listed in SQL> HELP RESERVED WORDS). What problems would using them as column names cause in Oracle? The database server ...
0
votes
1answer
25 views

LOAD DATA statement not working in Oracle SQL Developer

When I run the statement: LOAD DATA LOCAL INFILE 'C:/path/date.txt' INTO TABLE dimdate FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (date_id, yyyymmdd, fulldate, weekofyear, month, quarter, ...
0
votes
0answers
6 views

integrating a reporting tool with Oracle DB and Oracle CRM [closed]

AIM: To create a data warehouse where I can dump my data coming from Oracle DB and Oracle CRM on- demand. I have two data sources - Oracle DB and Oracle CRM on-demand. I have to create a data ...
3
votes
0answers
48 views

Why can an Oracle SET UNUSED COLUMN cause internal UPDATE SET X=X and huge log generation?

On Oracle 11.2.0.4.1, we tried to run a simple ALTER TABLE PARTITIONED_LARGE SET UNUSED COLUMN XXXXX; on a large ref-partitioned child table to decommission a column. The table has hundreds of ...
0
votes
0answers
35 views

Creating a trigger on Oracle 11g (beginner question) [migrated]

I need to create a trigger that updates another table whenever the trigger table has an insert into command, or an after insert trigger. I need to pull the id that's being inserted into the table in ...
-1
votes
0answers
13 views

Update Open Query for Oracle linked server [closed]

I return an open query for updating table data in oracle.whether i can use condition (CARD_NUMBER=tb3.cardno) inside openquery..?below is my query update openquery(link,'select ...
0
votes
1answer
22 views

How to view the original script that built a materialized view and that was created by another user?

In the Oracle database server use, another user (called MIMIC2DEVEL) created a materialized view and made it public. How to view the original script that was used to built it? Here are the grants on ...
-1
votes
0answers
29 views

Pointing SOA10g to OUD

Ok, I realized that my original formulation of my question was vague. The issue is that we have hit so many walls that it's really hard to be very specific without writing a book, so I'll try to be ...
2
votes
1answer
49 views

Regular expression in a SQL case statement

I have records formatted as such: CBS405/505 Fourth Week(Wtr Qtr) BR 404-504-604 Fifth Week(Fall Qtr) AP490-QB-09 Weekly Sessions(Spr Qtr) APR501 Fourth Week(Wtr Qtr) MP 300 Fourth Week(Wtr Qtr) ...
3
votes
0answers
62 views

How to track DML events ocurred in the current day

I have the following query to track what tables are modified in the current date: SELECT TABLE_OWNER, TABLE_NAME, INSERTS, UPDATES, DELETES, TIMESTAMP AS ...
0
votes
1answer
31 views

How to select a column to compare two values in it with AND [closed]

How to select a column to compare two values in it with AND select distinct c.reg#, a.fname, a.lname, to_char(b.L#) as "L" from employee a, driver b, trip c where a.e#=b.e# and b.l#=c.l# and ...
0
votes
1answer
21 views

Query DML code to determine source and target data [closed]

I looking to scan all of the procedures in our database in order to save off source and target table information for our data loads. I'm thinking there should be some sort of dba table which will give ...
0
votes
1answer
20 views

How to select data out of an Oracle collection/array?

Due to needing some complex data manipulation and not being able to use PHP, I crafted a procedure (not stored, it's just run when we run the query) in Oracle to manipulate the data and store it in an ...
0
votes
1answer
33 views

Oracle SQL Complications With Multiple Triggers

Hey all so I am creating a DB that is used going to be used for managing utilities of a system. My DB has 3 tables: Users, Utilites, and Files (leaving Files table out because question shouldn't ...
0
votes
2answers
44 views

inner join select - group by?

I have 2 tables (Oracle database): ANEXA2A_TABEL1: id fk_id_anexa pet1 pet2 alt1 alt2 1 123 10 1 20 2 2 321 11 2 10 3 ...
0
votes
1answer
44 views

Proper use of extract function? [closed]

I am trying to select names of employees who were born in 1985. I am doing this but it is giving me an error. SQL> select fname, lname, count(E#) as "total" 2 extract(year from date, dob) as ...
0
votes
1answer
22 views

How to exceute view without DBLink in oracle server

I have 2 views, example V1 from Database DB1 , V2 from database DB2, these 2 database server are remotely configured, I can able to execute these views separately without database link in the ...
1
vote
1answer
31 views

Load file based on line number in sqlldr

I am trying to load header and detail records from a file. The only way I know the difference between the header and the detail records is the line number. The first line is always the header and the ...
0
votes
2answers
73 views

Set Oracle Home (install Oracle Home) for Toad 12.6

I had Toad 11.5 and I'm trying to install Toad 12.6, to connect to Oracle 11g on a 64-bit Windows 7 machine. No matter what I try, when I start Toad 12.6, I get the error: "No valid Oracle clients ...
0
votes
1answer
33 views

Call trigger during SQL Loader insert

I'm trying to insert data from a file into an Oracle table using SQL loader. The primary key is populated by a sequence where the nextVal is called from an insert trigger. When I try using sqlldr, it ...
0
votes
1answer
70 views

How to view the latest entries in all tables in an Oracle DB? [closed]

I wanted to examine a running Oracle instance on one of our servers, but nobody knows, if there's still any data of interest stored in the database. Unfortunately our last Oracle admin has left our ...
0
votes
1answer
25 views

ORA-01722 Error when running stored procedure

I am trying to run a stored procedure however when I run it with an a valid Number it gives me an ORA-01722 error. I checked to make sure that the columns in the where clause where the parameter is ...