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

Is it possible to create a view in one database from another database in oracle when databases are different machine?

Lets say I have a oracle database db1(actually user) in machine A and another database db2 in machine B. Is it possible to create view in db2 from db1.If possible how ?
1
vote
0answers
16 views

Oracle Rac With Scan Error

I have installed Oracle RAC with ASM on Oracle Linux 5.8. My database version is 11.2.0.1. I have 2 node in my plan and all of them are active. I set scan in my DNS server but I can not connect to ...
0
votes
1answer
18 views

Formatting a DATE type in an Oracle database to only accept MMDD

Is there a way to limit the inputs into a DATE type in an Oracle database to only accept inputs formatted with only the day and month (not including the year)?
0
votes
0answers
22 views

CALL Procedure(Function) = Trigger?

I have discovered some strange behavior in Oracle 11g, and I'm wondering if anyone has an explanation for it. The gist is that when I use a function that contains a commit/rollback/savepoint within a ...
0
votes
1answer
28 views

Oracle 11.2.0.3 to 11.2.0.4

I'm planning to upgrade 3 instances of Oracle (all same Oracle Home) from 11.2.0.3 to 11.2.0.4. I'm going through the installer and I get to the question about Upgrade or install just the database ...
1
vote
1answer
35 views

Oracle - Using index on unique constraint, what the deal?

Using Druid to generate SQL script for Oracle, I have seen a difference between the version 3.10 and 3.13 and I would like to understand what going on. SQL generated by Druid 3.10 : CREATE TABLE ...
1
vote
1answer
33 views

How to set Persian calendar,currency,numbers,date and time and text in oracle database?

I have installed oracle database 12c on my laptop. I want to be able to store text,numbers,calendar,currency,... in my local language (Persian) in database tables and also show contents in Persian ...
0
votes
1answer
29 views

Is possible do an online snapshot backup , without archive logs at Oracle Database?

Using Oracle Database Standard Edition 11r2 . I'm looking a way to backup the database with zero downtime , using a snapshot of datafiles (LVM snapshots) and without need backup de archive logs. ...
0
votes
1answer
33 views

Why is my PL/SQL procedure so slow?

I have this sub-procedure in a fairly large program, and it is taking hundreds of times longer than comparable sub-procedures. Is there any way I could improve efficiency here? None of this ...
-4
votes
0answers
26 views

How to filter a column of type DATE THE MAXIMUM RECORD DATE IN OBIEE [on hold]

How to filter a column of type DATE THE MAXIMUM RECORD DATE
1
vote
1answer
27 views

Variable Substitution

I am working in TOAD for Oracle and am trying to use variable substitution in my coding. I have been able to get variable substitution to work in the code body pressing F5: Define Value = '1.5' ...
0
votes
0answers
20 views

Getting milliseconds elapsed during a stored PL/SQL procedure

I've been using sysdate to time procedures, but a lot of my procedures are very small procedures that get called thousands of times. Is there a way to get milliseconds elapsed instead of seconds? I ...
-1
votes
0answers
29 views

Stored procedure - list of strings as an out variable. How do I do this? [migrated]

I have a pl/sql procedure that will be called from a web application. It needs to return a list of Strings. How would I do this? Oracle Database 11g Release 11.1.0.6.0 - Production PL/SQL Release ...
0
votes
1answer
20 views

Oracle selective redo log shipping

We are planing to setup an Oracle 12c RAC with a Logical standby in the DR site. Since data consistency is extremely important, we our planning to setup redo log shipping to be in SYNC mode. Our ...
0
votes
1answer
31 views

Group-by in an Oracle database

on an Oracle database. If I make an: select id,id_operator,denumire,cod_fiscal,loc_den,str from rap where is_punct_lucru=1 and id_operator in ( select id_operator from rap where ...
1
vote
1answer
27 views

What does Oracle XE perform during installation?

I have oracle11g2 installed on my noteobook. I then installed the Oracle Database 11g XE. Now a .dll which uses the oracle11g2 client does not work anymore. First I recogniced that I had now two ...
0
votes
1answer
33 views

Apply operation on all schemas

I have an Oracle instance, with several schemas (all starting with the same prefix). PATT_A PATT_B PATT_C ... All of them have the same table, and I'd like to update all of them in one shot (with ...
2
votes
2answers
49 views

sqlplus (Oracle XE) doesn't start on CentOS 7

I followed the steps of this document: https://docs.oracle.com/cd/E17781_01/install.112/e18802/toc.htm#XEINL121, but sqlplus doesn't start. Even if I used the command: "sqlplus /nolog". The other ...
1
vote
0answers
35 views

SQL Server vs Oracle [on hold]

I am transitioning from SQL Server DBA to Oracle DBA. I have minimal experience with Oracle, and I have found that the best way for me to traverse if by correlating terminology and database engine ...
0
votes
0answers
34 views

Oracle trigger after insert error ORA-01403: no data found

I'm trying to make a trigger that select a value inserted in other table and concat with other value in an insert on other table that's my code CREATE TABLE "SEX" ( "ID" NUMBER, "CS" ...
1
vote
2answers
58 views

Stored procedure using cursors

I am attempting to create a procedure using cursors to list the average salary of all employees on a per department basis. I am using three tables, defined as emp (eid, ename, age, salary) works ...
0
votes
0answers
16 views

Printing comments or statements when executing script to a output file using TOAD/ORACLE

Coming from a SQL SSMS enviorment, I would like to duplicate their 'Print' Command which allows you to print commands or variables while executing a query. I am looking for this feature to help ...
0
votes
2answers
21 views

How to get the second string in the ORA-02296 error to show something meaningful

Whenever I run the following script*: ALTER TABLE ANIMAL.MONKEY MODIFY TAIL_COUNT NOT NULL; I receive the following error: ORA-02296: cannot enable (ANIMAL.) - null values found I have a ...
0
votes
0answers
24 views

Partitioning existing table in Oracle

(Oracle) I'm trying to do an exchange partition on an empty partitioned table to fill it with data from a non-partitioned table. I'm getting the following error and can't find the cause. I'm not 100% ...
0
votes
0answers
21 views

PL/SQL Triggers [migrated]

I am using these tables: flights (flno, origin, destination, distance, departs, arrives, price) aircraft (aid, aname, crusingrange) employees (eid, ename, salary) certified (eid,aid) and I need ...
0
votes
2answers
43 views

What is the privilege for account unlock in Oracle [on hold]

I want to understand the privileges better, but I'm not able to find some useful info using Google. I thought that I needed ALTER USER privilege to be able to unlock user and change password. But ...
0
votes
2answers
49 views

Oracle systimestamp result differs in db server and client

I am getting some strange output while executing the below command on db server and on client machine connected to same db server. On DB server SQL> select systimestamp from dual; systimestamp ...
0
votes
1answer
24 views

sqlplus connect without typing the @local_SID when only have one instance

Every time I want to connect with a user in Sqlplus I have to specify the database|sid name too, SQL>connect scott/tiger@orcl I have installed another database for other purpose but I removed ...
0
votes
1answer
23 views

Why would DBMS_METADATA.GET_DDL Fail when i have the SELECT_CATALOG_ROLE Role?

I am trying to get the DDL using METADATA_DBMS.GET_DDL for an object in a database, and I get the following error: ORA-31603: object "MY_PACKAGE" of type PACKAGE not found in schema "S1" ORA-06512: ...
-1
votes
0answers
28 views

Exchange Partition

I want to monthly move partitions of my current table into archive. For example, I have two tables with primary key constraint: create table tableSource( id number, create_date timestamp ...
1
vote
1answer
45 views

Understanding of schema and tablespaces - recommendation for a later seperation [closed]

DLDR: I would like to get a confirmation of my understanding of tablespaces and schemas (see image) a recommendation how to organize schemas and tablespace to make a later separation easy. ...
0
votes
0answers
24 views

How can I install Oracle (10g or above) on my MacBook running OS X Yosemite (10.10.4)? [closed]

I did a fair bit of research on it and I read that it can be done with a virtual machine (as Oracle stopped its support for OS X, even 10g page is taken off from official site) but I'm looking for a ...
0
votes
2answers
31 views

DBMS_REDEFINITION don't copy data?

Is there an option to use Oracles online table redefinition feature but only copy a subset of the data from the source table? I mean - the source table has 2M records and I want to only copy those ...
0
votes
0answers
11 views

Oracle: Recursively self referential join with nth level record

I have self referential table like this: id |level | parent_id ---------------------- 1 |1 |null 2 |1 |null 3 |2 |1 4 |2 |1 5 |2 |2 6 |3 |5 7 |3 |3 ...
0
votes
0answers
25 views

(Oracle PL/SQL) How to capture multiple error lines in exception section?

begin some SQL...; exception send_SMS('SQL error: '||SQLERRM); end; This sometimes reports: ORA-02063: preceding line from DBLINK_NAME How to capture the preceding error lines in a PL/SQL ...
1
vote
2answers
81 views

Is index performance on a TIMESTAMP(6) column impacted when converting it to a number

If I have an index on a TIMESTAMP(6) column, am I forced to use this column as a TIMESTAMP(6) to get the benefits of the index? Can I convert this column to a number with second precision ...
0
votes
3answers
45 views

Will an update in my trigger trigger itself? Oracle PLSQL

Here's my PLSQL trigger: CREATE OR REPLACE TRIGGER ROOT_CHANGING_TRG BEFORE UPDATE OF ROOT_ID,PARENT_PHYS_ID ON UNIQUE_PHYSICIAN FOR EACH ROW DECLARE var_root number := :new.ROOT_ID; var_par number ...
0
votes
1answer
28 views

Error while updating a date column using SQL*Plus variable

I am not able to update the date time which I have already stored in a variable and I am trying to update the another record with date time present in that variable. last_update_time=`sqlplus -s ...
2
votes
0answers
27 views

Oracle 12c connection to SQL Server 2014

I have installed Oracle 12c on Centos 7 and I wanted to connect SQL Server 2014 using freeTDS so I installed: FreeTds. unixODBC. then configured odbc on the linux so when I run isql dsn username ...
0
votes
0answers
24 views

Oracle 11g installation on fedora 20 - stuck at step6 - Oracle-base.com installation procedure

I am trying to install Oracle Database 11g Release 2 (11.2.0.1) On Fedora 20 (F20)Oracle 11g in my laptop and I am following the steps provided in this Link But it is getting stuck after step 6. Can ...
0
votes
0answers
16 views

oracle database 12c

When starting up automatic instance INSTANCE: RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== ...
0
votes
0answers
35 views

Update a column in table only if a condition is met for number of values for a field in other table

I am trying to figure out how to achieve the following (This is simplified version that ignores non relevant columns) I have table "Item" with columns item_id business_key I have another table ...
0
votes
2answers
25 views

List full text indexes in Oracle database

Using SQL Server, it's possible to execute a query that returns all the columns that contain a full text index. How can I do something similar using Oracle? Is it possible?
0
votes
1answer
29 views

Lookup multiple ids in seperate table with 2 subquerys

I have a query from a timesheets tables that I am using to select a submitter, approver, and a date. SELECT PRTIMESHEET.POSTED_TIME, PRTIMESHEET.PRRESOURCEID as "SUBMITTER", ...
4
votes
2answers
99 views

Cummulative Sum with Reset Value

Consider the following table: ID | GROUP_ID | ORDER_VAL | RESET_VAL | VAL ---+----------+-----------+-----------+----- 1 | 1 | 1 | (null) | 3 2 | 1 | 2 | (null) ...
2
votes
1answer
19 views

Why does DBMS_SESSION.session_trace_enable create multiple files?

I have a trace on a session configured like this: execute immediate 'ALTER SESSION SET TRACEFILE_IDENTIFIER = ''TEST1'''; DBMS_SESSION.session_trace_enable (waits => TRUE, ...
0
votes
2answers
43 views

Use column alias in GROUP BY

I have a query where I chain two columns. Why does the alias not work in the GROUP BY clause but in ORDER BY clause, it does work? How can I write the select correctly? SELECT KOS_VER_ID AS ...
1
vote
2answers
88 views

Why is my query returning an unexpected result?

Here are the tables I am using: parts(pid,pname,color) suppliers(sid,sname,address) catalog(sid,pid,cost) I need to find the name of suppliers that supply two different parts with the same ...
0
votes
1answer
20 views

Oracle SQL: update only some records

I search an update-command, which update me only some records (more than one row) in a table. The update Information comes from an other table. Unfortunately it updates all 3500 records instead of ...
-1
votes
0answers
20 views

Oracle sqlplus report

I try to make a sqlplus report like that: A B C D --- --- --- --- 1 A Z 100 2 A Y 100 COUNT 2 TOTAL 200 ------------------------- 3 B ...