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
0answers
15 views

**Homework/Research** for future Database Administrator [on hold]

Considering I am pretty new to software development/programming I decided to do a technical writing report researching what programming languages are best suited for students wanting to pursue a ...
0
votes
0answers
5 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 ...
1
vote
1answer
17 views

trigger or check constraint insert values based upon existence of others

For simplicity (and since it captures the essence of my problem), suppose I have a table with data. CREATE TABLE my_practice_table ( my_id NUMBER(12), field_2 VARCHAR2(20), field_3 ...
0
votes
0answers
8 views

Dmp file import create triggers error

I've taken a full database backup from one server to be moved to another using the following command (both using Oracle 11g): exp SYSTEM/password@db1 full=y grants=y rows=y file=backup.dmp And now ...
0
votes
0answers
7 views

write data on multiple storageNodes in oracle NoSQL

I'm using oracle NoSQL on ubuntu (newbie to both) and created 3 storageNodes (with 3 RN on each) in one computer on different ports (5000,6000 and 7000) in a store named mystore. Now I need to write 1 ...
1
vote
1answer
19 views

Re-import packages in Oracle

I'm aware of options to re-import data to tables using table_exists_action and can give options like skip,append or replace for the data. But is there an option to re-import packages (re-create) into ...
-2
votes
0answers
14 views

Calculate percentage of a column group by 2 columns in pivot table format using oracle 11g sql [on hold]

I would like to request help displaying count of a column and respective percentage of a column as in pivot table. I tried several options of which I yielded 18 rows when used kind of select first ...
-1
votes
1answer
18 views

Connect to Oracle remote Database by only installing a client on my laptop?

Is it possible to connect to remote oracle database from my laptop if I only install instant client, without installing oracle database? I have the tnsnames.ora and listener.ora files in ...
0
votes
1answer
22 views

How connect by is really working? How is it multiplying rows?

I know (on high abstract level) how hierarchies in Oracle works, but this one I do not understand. When issued following query: select rownum-1 as num from dual I've got one row as result. The ...
1
vote
0answers
14 views

(VS Comm./VB6) How to Select from 2 different data sources/formats in one query?

I have two working TableAdapterQueries in my project, one selects from a MySQL database on a virtual server I own, the other is an Oracle PL/SQL database on a separate server. The data (and ...
2
votes
1answer
28 views

Oracle 11g hash join vs nested loops question

I'm using Oracle 11g and working on a legacy system. I have two tables, A and B. A has ~40M rows and B ~4M rows. A has a foreign key on B (B is the parent of A). A query does essentially this: ...
-1
votes
0answers
16 views

Can I connect to remote oracle database without local oracle database installed? [on hold]

Say for example, I have sqlplus. I don't have oracle database installed. How can I connect to a remote computer oracle database from my sql client? I am running solaris. Should I make a tnsnames.ora ...
-2
votes
1answer
33 views

Generate create table DDL from any arbitrary select query? [on hold]

Is there a way, given any arbitrary select query like: select myfavoritenum, myfavoritetxt from tablewithmanycolumns and magically receive a create table statement: create table justmyfavorites ( ...
0
votes
1answer
25 views

Oracle Conditional sum

This question was born in my mind looking at this kind of code: select sum(value) into positive from my_table where value > 0; select sum(value) into negative from my_table where value ...
1
vote
1answer
27 views

cluster_database TRUE/FALSE what does it mean in Oracle RAC?

I have 3 databases on an Oracle RAC (two nodes) one database which is running with CLUSTER_DATABASE=TRUE on both nodes, the other two runs on each node with CLUSTER_DATABASE=FALSE what does it mean ...
0
votes
1answer
30 views

Strategies to import big data into oracle

Which strategies are available to import very larg amount of data from an external system which is delivering about 500 million small transactions every day? Oracle becomes very slow with high ...
1
vote
1answer
25 views

Delete Old Archivelogs from missing database

We have deleted a database but the archive logs remain. We need to delete these as they take a lot of space: Since the database is deleted, it is not in the rman catalogue so I cannot use delete ...
3
votes
1answer
47 views

dbms_datapump API exclude statistics during import

We are using dbms_datapump to copy data between different servers or to setup new schemas quickly. However importing statistics usually takes ages and has the additional disadvantage that schema ...
0
votes
1answer
37 views

Import big CSV on Oracle

I have big CSV files and placed it on Linux (Amazon AMI). I have installed instant client on Amazon Linux AMI and I can connect to my Oracle database using SQL Plus. How can I import all the CSVs to ...
-1
votes
0answers
45 views

creating BTREE index in oracle with clause [closed]

I am sorry that I confused. Let me explain my situation. I pull data from Data Warehouse where fact table is joined to dimension tables through dim_id's. I do have only select privileges on tables. I ...
0
votes
0answers
33 views

WHENEVER OSERROR suppresses error messages

$ sqlplus <connstring> 2>&1 <<! WHENEVER SQLERROR EXIT FAILURE ROLLBACK; WHENEVER OSERROR EXIT FAILURE ROLLBACK; SET ECHO ON; @nonex.sql; ! Produces SQL*Plus: Release 11.2.0.1.0 ...
0
votes
0answers
46 views

How to downgrade Oracle Database from 11gr2 to 10g?

In certain situation i have to downgrade from 11gr2 to 10g but coudn't find right way to downgrade. Can you please give a right direction and possible causes to Database.!
0
votes
1answer
34 views

Oracle: How to AUTOTRACE in my program

You can display the results of EXPLAIN PLAN with explain plan for select * from foo; select * from table(dbms_xplan.display); How can I similarly display the results for an AUTOTRACE in my program? ...
0
votes
1answer
49 views

Oracle: Am I on a RAC?

What query can I perform to determine if I am running on a RAC system? If I'm on a RAC, I need to query from GV$* rather than V$*.
1
vote
1answer
55 views

Oracle: guaranteeing unmodified database state with queries?

If the first word of a SQL statement is either WITH or SELECT, is the statement guaranteed not to change the state of the database? i.e. is this loop "safe"? read SQL string if string begins with ...
0
votes
0answers
12 views

Search and compare input data with historical data in oracle [closed]

I have a requirement to compare transaction data with existing historical data available in a large table. Comparison aarameteps are defined in the system(e.g. receiver name,sender name etc). There ...
0
votes
0answers
34 views

Error PRVG-11322 while atempting to install ODAC 12c release 3

I've been trying to install the oracle developper tools with ODAC update 3 (because I need it to work with Entity framwork 6) but the Unified installer bring me a PRVG-11322 Error. It seem to be ...
1
vote
0answers
23 views

How can you re-synchronize oracle streams automatically?

I have noticed that when a process of oracle streams (e.g. capture/apply/propagate) is stopped or disabled, and at the same time, changes are made to the source and/or destination ...
0
votes
1answer
32 views

jdbc connection string ORACLE , integrated security

we are trying to configure Spotfire to use JDBC connection to ORACLE. We would like it to use integrated security (I call it Active Directory, TIBCO seems to like integrated security). Here is the ...
0
votes
0answers
29 views

Oracle MODEL clause: Carry yesterday's leftovers to today

I'm new to the MODEL clause. I'm trying to track volume of worked/unworked to-do items over time. What I HAVE is: work_date born (# of new to-dos per date), robo (# of computer-closed to-dos ...
-4
votes
0answers
36 views

Oracle to SQL Server query conversion. Getting “Argument data type int is invalid for argument 1 of substring function.” error

I tried to convert a SQL query from Oracle to SQL Server. Oracle query: SELECT T@o_NUMBER(T@o_CHAR(GETDATE(),'HH24')), T@o_NUMBER(SUBSTR(T@o_NUMBER(T@o_CHAR(sysdate,'MI'))/15+1,0,1)) INTO ...
-4
votes
1answer
22 views

From keyword not found? [closed]

SET ECHO ON SET HEADING OFF SET FEEDBACK OFF SELECT * FROM GLOBAL_NAME; CREATE TABLE CAR(REGO CHAR(8) NOT NULL, MAKE VARCHAR(20) NOT NULL, CONSTRAINT CAR_PKEY PRIMARY KEY("REGO")); INSERT INTO CAR ...
0
votes
2answers
58 views

Oracle query optimization

We have a query that runs on a view and its execution time is about 6 min. SELECT COUNT(*) FROM someschema.item_total_violations WHERE channel_id = 122507833 AND item_date >= ...
0
votes
2answers
30 views

What is an easy query to fix up historical columns valid_from and valid_to?

I have a table with typical history rows using valid_from and valid_to dates. My table might look like this: | id | object_id | name | valid_from | valid_to ...
0
votes
0answers
25 views

Rman append archivelog to backup

is it possible to configure RMAN to append archivelogs to backup automatically? I know that it is possible to issue BAKCUP DATABASE PLUS ARCHIVELOG but, is it possible to configure rman to do this ...
0
votes
1answer
42 views

Oracle DB Point In Time Recovery faulted

I'm testing a procedure via RMAN backup to retore/recover at recover-point, but it fails. Exactly I've executed the first time and it works: Backup: RMAN> backup database INCLUDE CURRENT ...
0
votes
2answers
46 views

Oracle DB license for only non-production environments [closed]

My company is a software vendor. We develop software that is later deployed on the customer's environment, on their own machines. Our software uses various DBMS, depending on what the customer has. We ...
0
votes
1answer
31 views

Oracle: Traversing a graph of my foreign keys?

Given a table, what is a query that will show foreign key constrains, both immediate and nested? I.e. if T2 has an FK on T1, and T3 has an FK on T2, I would like to show T1 -> T2 -> T3.
1
vote
2answers
54 views

Oracle: finding rows without children in a table with a foreign key?

Suppose I have two tables with a foreign key relationship. How can I find the rows in the parent table for which there is no corresponding child record? For example: create table a(x number primary ...
0
votes
1answer
24 views

Oracle Database Migration using Oracle SQL Developer

I've 2 Oracle database on different machines [I connect to them via oracle SQL Developer Now I am planning to have machine 3 which will consolidate both Oracle instances on one new node Question ...
0
votes
2answers
60 views

Why is Oracle's number datatype so HUGE? and why do I seem to have no alternatives?

Oracle has a favorite numerical class called NUMBER. It is a 22 byte value that just seems ludicrous in an index. I have some values that would easily fit in a 6 byte integer and would therefore fit ...
0
votes
0answers
13 views

Only 'SESSION REC' in ACTION_NAME column

I was asked to generate a report of operations performed on certain Oracle 9i tables in a given period of time. When I query the DBA_AUDIT_TRAIL table I only get SESSION REC in the ACTION_NAME ...
0
votes
1answer
49 views

Can Oracle have too much RAM?

Our database is slow in some very important use cases. I have traced it to a problem with some queries performing full text searches and single row accesses on a lot of records (db file sequential ...
1
vote
0answers
31 views

Oracle listener configuration

I have oracle 11.2.0 installed on linux. And I have arcgis server 10.2 on the same machine. I created an geodatabase. But when i try the sde functions like sde.st_asText i got: -ORA-28575: unable to ...
0
votes
1answer
36 views

ORA-19809 & ORA-12560

Following some maintenance on our server (change raid battery + reboot) my database (Oracle 11g) is not available anymore. I m a newbie in Oracle and I have been through the forum and I can t find the ...
0
votes
0answers
16 views

Oracle database as a single synchronization point for two separate web applications [migrated]

I am considering using an Oracle database to synchronize concurrent operations from two or more web applications on separate servers. The database is the single infrastructure element in common for ...
1
vote
0answers
45 views

Oracle: built in SQL pretty-print?

Oracle has some packages that will dump objects in SQL format, such as dbms_metadata.set_transform_param. One option that can be set is to "pretty print" the SQL. Is there anything in Oracle that ...
0
votes
1answer
54 views

Oracle 11.2 restore DB to a specific point

I should execute following tasks: 1. test system and during test change Oracle data and Create New/Remove Old datafiles and tablespace. 2. at the end of test rollback to behviour before of point 1. ...
0
votes
0answers
47 views

Slow running Oracle query caused by unnecessary full table scan

I'm by no means an expert with Oracle, but I know enough in terms of how to analyze explain plans and perform basic optimizations. However, this time, Oracle has stumped me with it's explain plan. ...
0
votes
0answers
41 views

Script to automatically Identify tablespaces above threshold and bring it back to below threshold value

I am facing all the tablespaces crossing threshold problem in all most all the databases we have in our environment. Because of this much manual effort is been needed. I am able to identify the ...